pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
TEXT type blob extraction in ecpg
2+ messages / 2 participants
[nested] [flat]

* TEXT type blob extraction in ecpg
@ 2005-01-10 17:43  none none <mytofi@hotmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: none none @ 2005-01-10 17:43 UTC (permalink / raw)
  To: pgsql-sql


Does any one know how to properly extract a TEXT type blob (undefined char 
length) in ecpg (Linux system)?  We are converting our SQL from Informix to 
PostGres.  Informix had a specific struct defined and I believe handled the 
dynamic memory allocation, but I cannot find any guidance on this issue for 
PostGres.  Anyone have any suggestions?

Thanks,

Tom





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: TEXT type blob extraction in ecpg
@ 2005-01-17 07:33  KÖPFERL Robert <robert.koepferl@sonorys.at>
  0 siblings, 0 replies; 2+ messages in thread

From: KÖPFERL Robert @ 2005-01-17 07:33 UTC (permalink / raw)
  To: pgsql-sql

I think don't really unterstand your intend.
However there exists a type text in SQL and Postgres which is a text of
unspecified length and used like a SQL-String. Thus quoted with '

So when you earlier were able to gain the content of that field. It should
be no problem to quote it.

> -----Original Message-----
> From: none none [mailto:mytofi@hotmail.com]
> Sent: Montag, 10. Jänner 2005 18:43
> To: pgsql-sql@postgresql.org
> Subject: [SQL] TEXT type blob extraction in ecpg
> 
> 
> 
> Does any one know how to properly extract a TEXT type blob 
> (undefined char 
> length) in ecpg (Linux system)?  We are converting our SQL 
> from Informix to 
> PostGres.  Informix had a specific struct defined and I 
> believe handled the 
> dynamic memory allocation, but I cannot find any guidance on 
> this issue for 
> PostGres.  Anyone have any suggestions?
> 
> Thanks,
> 
> Tom
> 
> 
> 
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faqs/FAQ.html
> 



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-01-17 07:33 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-01-10 17:43 TEXT type blob extraction in ecpg none none <mytofi@hotmail.com>
2005-01-17 07:33 Re: TEXT type blob extraction in ecpg KÖPFERL Robert <robert.koepferl@sonorys.at>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox