Re: [SQL] AGE function

2005-09-06 Thread Michael Fuhr
On Tue, Sep 06, 2005 at 10:05:06PM -0700, Louise Catherine wrote: > When I execute this statement : > select AGE(TO_DATE('20041101','mmdd'), > TO_DATE('19991201','mmdd')) > > at postgre 7.3.3, the result : > age > - > 4 years 11 mons 1 day > >

[SQL] AGE function

2005-09-06 Thread Louise Catherine
When I execute this statement : select AGE(TO_DATE('20041101','mmdd'), TO_DATE('19991201','mmdd')) at postgre 7.3.3, the result : age - 4 years 11 mons 1 day at postgre 8.0.3, the result : age --- 4 years 11 mons

Re: [SQL] Statistics from Sequences

2005-09-06 Thread Bruno Wolff III
On Tue, Sep 06, 2005 at 23:43:44 -0300, Joÿffe3o Carvalho <[EMAIL PROTECTED]> wrote: > Is it possible to get from a sequence: > >The sequence owner >The min value >The max value >The increment value >The last used number Yes. Associated with each sequence is a one ro

Re: [SQL] Statistics from Sequences

2005-09-06 Thread Michael Fuhr
On Tue, Sep 06, 2005 at 11:43:44PM -0300, Joÿffe3o Carvalho wrote: > Is it possible to get from a sequence: > >The sequence owner >The min value >The max value >The increment value >The last used number See the output from the following example: CREATE SEQUENCE fooseq

[SQL] Statistics from Sequences

2005-09-06 Thread Joÿffffffffffe3o Carvalho
Is it possible to get from a sequence: The sequence owner The min value The max value The increment value The last used number ??? Regards Yahoo! Messenger com voz: PROMOÇÃO VOCÊ PODE LEVAR UMA VIAGEM NA CONVERSA. Participe!

Re: [SQL] Recommendation on bytea or blob for binary data like images

2005-09-06 Thread Leon Torres
Thanks for the quick response. We will be using bytea from now on. :-) - Leon Tom Lane wrote: [EMAIL PROTECTED] writes: Hi, I'd like to know what the official recommendation is on which binary datatype to use for common small-binary size use. If bytea will work for you, it's definit

Re: [SQL] POSIX Regular Expression question

2005-09-06 Thread Bruno Wolff III
On Mon, Sep 05, 2005 at 16:19:28 +0200, Peter Eisentraut <[EMAIL PROTECTED]> wrote: > Am Montag, 5. September 2005 15:57 schrieb Aldor: > > I want to get out a string only with characters A-Za-z. > > Any idea how to do this in Postgres with POSIX Regex? > > Presumably, > > colname ~ '^[A-Za

Re: [SQL] Help with UNION query

2005-09-06 Thread Bruno Wolff III
On Sun, Sep 04, 2005 at 20:54:00 +0200, Andreas Joseph Krogh <[EMAIL PROTECTED]> wrote: > > So, the question stands: any idea on how to rewrite the lower wuery to only > specify "ug.username='andreak'" once? Why do you want to do that? This isn't going to help with performance and may actually

Re: [SQL] Searching for results with an unknown amount of data

2005-09-06 Thread Bruno Wolff III
On Fri, Sep 02, 2005 at 20:40:24 +0100, DownLoad X <[EMAIL PROTECTED]> wrote: > Now, I want to find all objects that have at most properties 1,2,3, say (so > something with (1,2) is okay, as is (1,2,3)). I can't see a way to do this > -- can anyone help? It sounds like you are trying to find a

Re: [SQL] ERROR: syntax error at or near "select" at character 9

2005-09-06 Thread Stephan Szabo
On Tue, 6 Sep 2005, Harald Fuchs wrote: > In article <[EMAIL PROTECTED]>, > Stephan Szabo <[EMAIL PROTECTED]> writes: > > > On Fri, 2 Sep 2005, [ISO-8859-2] Graf László wrote: > > >> > >> CREATE FUNCTION test_verif() RETURNS trigger AS $test_verif$ > >> BEGIN > >> NEW.id := select nextval('test_az

Re: [SQL] ERROR: syntax error at or near "select" at character 9

2005-09-06 Thread Harald Fuchs
In article <[EMAIL PROTECTED]>, Stephan Szabo <[EMAIL PROTECTED]> writes: > On Fri, 2 Sep 2005, [ISO-8859-2] Graf László wrote: >> >> CREATE FUNCTION test_verif() RETURNS trigger AS $test_verif$ >> BEGIN >> NEW.id := select nextval('test_azon_seq'); > I think you want to remove select here, you'