Re: how to extract and use a string like a constraint?

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