BUG #4207: EXTRACT function - Mailing list pgsql-bugs

From Jeferson Kasper
Subject BUG #4207: EXTRACT function
Date
Msg-id 200805290701.m4T71kVf068203@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #4207: EXTRACT function  (Sam Mason <sam@samason.me.uk>)
List pgsql-bugs
The following bug has been logged online:

Bug reference:      4207
Logged by:          Jeferson Kasper
Email address:      jefersonkasper@gmail.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.

pgsql-bugs by date:

Previous
From: "Thomas H."
Date:
Subject: Re: BUG #4186: set lc_messages does not work
Next
From: "Dave Page"
Date:
Subject: Re: BUG #4186: set lc_messages does not work