Re: Getting char * from timestamp in a composite type

[Michael Akinde <michael.akinde@xxxxxx>]

Martijn van Oosterhout wrote:

On Wed, Dec 19, 2007 at 04:40:38PM +0100, Michael Akinde wrote:
  

As I understand it, I should be able to do something like (assuming 
"time" is the attribute name):

   bool isNull;
   HeapTupleHeader t = DatumGetHeapTupleHeader(row);
   Datum var = GetAttributeByName( row, "time", & isNull );
   // Check for null
   char * ret = DatumGetCString( DirectFunctionCall1(textout, var ) );
    

That's not going to work. textout wants a text datum. Try calling
timestamp_out instead..

Sigh... it's always the idiot bugs that are the hardest to see. Thanks a lot.

Regards,

Michael A.

begin:vcard
fn:Michael Akinde
n:Akinde;Michael
org:Meteorologisk Institutt, Norge;IT
adr;quoted-printable:;;Gaustadall=C3=A9en 30D;Oslo;;0313;Norge
email;internet:michael.akinde@xxxxxx
tel;work:22963379
tel;cell:45885379
x-mozilla-html:FALSE
url:http://www.met.no
version:2.1
end:vcard

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq