From: | "Jeferson Kasper" <jefersonkasper(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #4207: EXTRACT function |
Date: | 2008-05-29 07:01:46 |
Message-ID: | 200805290701.m4T71kVf068203@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4207
Logged by: Jeferson Kasper
Email address: jefersonkasper(at)gmail(dot)com
PostgreSQL version: 8.1.5
Operating system: Windows XP and Linux Redhat
Description: EXTRACT function
Details:
Hello.
First... sorry for poor english :)
My problem is quite simple.
the EXTRACT(field FROM source) function allows to use some kind of 'fields',
and i need to know if a time (like '07:00') is after the midday(12:00) or
not.
I know i can resolve it implementing some function like "select
('07:00'<'12:00')".. i just want to know if is difficult to implement a new
field called 'am', to use like.
select extract(AM from '07:00');
?column?
--------
t
i hope its not difficult, and i should use it, if it become available ...
Thanks for all.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2008-05-29 08:33:26 | Re: BUG #4186: set lc_messages does not work |
Previous Message | Hannu Krosing | 2008-05-29 06:44:34 | Re: BUG #4204: COPY to table with FK has memory leak |