| From: | Alvaro Herrera <alvherre(at)atentus(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: get date in binary number format |
| Date: | 2002-09-27 03:31:06 |
| Message-ID: | Pine.LNX.4.44.0209262330080.26247-100000@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tom Lane dijo:
> "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> writes:
> > I get this when I try the following select:
>
> > testdb=> select "bit"((date_part('doy', now()))::integer);
> > ERROR: Function 'bit(int4)' does not exist
>
> In CVS tip I get
>
> regression=# select "bit"((date_part('doy', now()))::integer);
> bit
> ----------------------------------
> 00000000000000000000000100001101
> (1 row)
Is there a way to cast these bitstrings into varchars or something? I
can't find any.
--
Alvaro Herrera (<alvherre[a]atentus.com>)
Hi! I'm a .signature virus!
cp me into your .signature file to help me spread!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-09-27 03:56:23 | Re: Fwd: Sizes of sequences and serials |
| Previous Message | Tom Lane | 2002-09-27 03:07:44 | Re: [HACKERS] Performance while loading data and indexing |