Re: EXECUTE problems

Have u define a value for Default ? / Vc definiu um valor para Default?

On 22 Nov 2002 12:25:46 -0200
Felipe Schnack <felipes@ritterdosreis.br> wrote:

>   I compiled the cvs version of pgsql yesterday afternoon and I'm having
> some problems with EXECUTE statement. If I do the following the query is
> executed:
>
> PREPARE TEST_STATEMENT_1(text) AS insert into teste values ( $1 );
> EXECUTE TEST_STATEMENT_1(null)
>
>   But why this doesn't?
>
> PREPARE TEST_STATEMENT_1(text) AS insert into teste values ( $1 );
> EXECUTE TEST_STATEMENT_1(DEFAULT)
>
>   Btw, the field is a varchar.
>
> --
>
> Felipe Schnack
> Analista de Sistemas
> felipes@ritterdosreis.br
> Cel.: (51)91287530
> Linux Counter #281893
>
> Faculdade Ritter dos Reis
> www.ritterdosreis.br
> felipes@ritterdosreis.br
> Fone/Fax.: (51)32303328
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>


--
Renê Salomão
Ibiz Tecnologia -- www.ibiz.com.br
(011) 5579-3178 - R. 211