Skip site navigation (1) Skip section navigation (2)

Re: ecpg and VARCHAR

From: Michael Meskes <meskes(at)postgresql(dot)org>
To: Dirk Jagdmann <doj(at)cubic(dot)org>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: ecpg and VARCHAR
Date: 2005-07-16 21:54:09
Message-ID: 20050716215409.GA13517@1 (view raw or flat)
Thread:
Lists: pgsql-interfaces
> I'd like to get some information on VARCHAR types with ecpg. If I 
> declare a VARCHAR without any size information I get a compilation error 
> from my gcc 3.4.4:
> ...
> Now I suppose this negative declaration should have initialized an empty 
> array and the generated sql code then allocates the space as needed?

This is definitely a bug. The negative value is used internaly but
should not make it into the generated code.

> If I declared the VARCHAR with a size everything works fine. However I'd 
> like to know if the characters in the array contain a trailing 0 or if I 
> have to set this explicitely?

No, they don't unless you set it to 0.

> And then I'd like to know which is the preferred way to retrieve "text" 
> columns which contain arbitrary length texts with ecpg?

Just use "char *ptr=NULL;" libecpg will then allocate the needed memory
for you. You just have to free it later.

But then, this should also work with varchar. :-)

Michael
-- 
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes(at)jabber(dot)org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

In response to

pgsql-interfaces by date

Next:From: Richard JonesDate: 2005-07-18 13:03:37
Subject: Parse a statement, get parameter types and return types
Previous:From: Scott CainDate: 2005-07-13 17:51:12
Subject: Re: Support for DBD::PgSPI with Pg 7.4.8?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group