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:)
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 |