Yes, I did... sorry, the error message was "parser: parse error at or
near "default" at character 26". Seems to me that execute doesn't "know"
DEFAULT keyrword?
On Fri, 2002-11-22 at 13:18, Renê Salomão wrote:
> 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
--
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