From: Postgres <postgres(at)www(dot)ienet(dot)hu>
To: undisclosed-recipients:;
Subject:
Date: 1998-07-23 11:12:45
Message-ID: 199807231112.NAA03186@www.ienet.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all

How can i put limited length varchar(20) to SQL function?
I have:
create table bb (
c varchar(20),
d int4
);

create function ins ( ???varchar???, int4) returns int4
as 'insert into bb (c, d) values ($1, $2);
select 1;
'
language 'sql'
;

but if i:
select ins('foo', 1);

then:
select * from bb;
c | d
---+------
foo|340322
(1 row)

340322 != 1 ?????

How can i fix this ?

Thank you for reading !
And many many thanks for answering !

Bye
kep:)

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Tong 1998-07-23 12:48:54 Re: [INTERFACES] ODBC Driver
Previous Message Maarten Boekhold 1998-07-23 09:23:37 Re: [GENERAL] ODBC Driver