Re: how to extract and use a string like a constraint? - Mailing list pgsql-novice

From Jean-Yves F. Barbier
Subject Re: how to extract and use a string like a constraint?
Date
Msg-id 20100707224517.26863605@anubis.defcon1
Whole thread Raw
In response to Re: how to extract and use a string like a constraint?  (Tim Landscheidt <tim@tim-landscheidt.de>)
List pgsql-novice
Le Wed, 07 Jul 2010 20:31:50 +0000,
Tim Landscheidt <tim@tim-landscheidt.de> a écrit :

> "Jean-Yves F. Barbier" <12ukwn@gmail.com> wrote:
>
> > [...]
> > and I also don't understand why this don't work:
> > SELECT char_length(SELECT chk FROM tstchk WHERE id=1);
> > Can it only be use with a temp var into a proc?
>
> You have to use parentheses around the "SELECT" query,
> i. e.:
>
> | SELECT char_length((SELECT chk FROM tstchk WHERE id=1));

Thanks Tim (I tested many signs but this one)

--
semper en excretus

pgsql-novice by date:

Previous
From: Thom Brown
Date:
Subject: Re: how to extract and use a string like a constraint?
Next
From: Thom Brown
Date:
Subject: Re: how to extract and use a string like a constraint?