Hi Gregory On Thu, 29 Nov 2007, Gregory Stark wrote: > Date: Thu, 29 Nov 2007 14:34:57 +0000 > From: Gregory Stark <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Cc: pgsql-hackers list <pgsql-hackers@postgresql.org> > Subject: Re: convert int to bytea > > <[EMAIL PROTECTED]> writes: > > > select 124::bytea doesn't work > > > > Is there an other way? (preferabily simple :) > > This kind of question would be more appropriate on pgsql-general. > I know, I should subscribe :)
> What do you want the resulting bytea to look like? > example : id = 9 , bytea = '\000\000\011' IIRC > -- Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) 15, Chemin des Monges +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: [EMAIL PROTECTED] ------------------------------------------------------------------------------ Make your life a dream, make your dream a reality. (St Exupery) ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
