Gonzo Rock <[EMAIL PROTECTED]> writes:
> Are all the date time functions described in the pgSQL docs are
> ANSI-SQL or pgSQL extensions?
One or the other, yes ;-)
EXTRACT() is ANSI, though I think we may accept a few more field keywords
than the spec mentions.
regards, t
Curious to know...
Are all the date time functions described in the pgSQL docs are ANSI-SQL or pgSQL
extensions?
For Example in the Docs:
4.7.1. EXTRACT, date_part
EXTRACT (field FROM source)
The extract function retrieves sub-fields from date/time values, such as yea
I also think two underscores make a literal underscore. Same with %.
> On Sat, 28 Jul 2001, Roy Souther wrote:
>
> > In PG the _ is a wildcard that means any singal char. I need to do a search
> > for the actual _ char and not get back thousands of wrong matches. Is there
> > and escape char
Philip Warner <[EMAIL PROTECTED]> writes:
> This will work, but will not solve the larger problem of 'give me all the
> attrs of of the record with the least datetime for a given SID'. Jeff does
> not need this, but it is a common problem. Simply using min/max works for
> one attr, but fails to pr
