[Dachs-support] unknown data type 'L' in FITS booster
Markus Demleitner
msdemlei at ari.uni-heidelberg.de
Tue Nov 22 09:49:55 CET 2016
Hi Carlos,
On Mon, Nov 21, 2016 at 09:16:38AM -0200, carlosadean at linea.gov.br wrote:
>
> ./sample/s.rd
>
> <column name="SNX3" type="bytea" description="" ucd="" unit="">
> <values nullLiteral="-9999" />
> </column>
>
>
> [carlosadean at devel2 inputs [master]]$ psql -h desdb4 -U gavo gavo
> psql (8.4.1, server 9.2.9)
> WARNING: psql version 8.4, server version 9.2.
> Some psql features might not work.
> Type "help" for help.
>
> gavo=# select snx3 from sample.fits limit 10;
> snx3
> ------
> \x00
> \x00
> \x00
> \x00
> \x00
> \x00
> \x00
> \x00
> \x00
> \x00
> (10 rows)
Looks all right to me -- declaring snx3 as bytea (which I recommend
against, since bytea as "tiny int" has issues; just use smallint)
leads to
gavo=# select distinct snx3 from txt.fits;
snx3
--------
\x0000
\x0001
on my box, which is what I'd expect.
Cheers,
Markus
More information about the Dachs-support
mailing list