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:)
- No Subject Przemyslaw Bak
- No Subject lj644f
- No Subject Postgres
- No Subject Anand
- No Subject Doug Smith
- [GENERAL] Re: Sferacarta Software
- No Subject mascarim
- No Subject Hub.Org News Admin
- No Subject Hub.Org News Admin
- No Subject Yury Don
- [GENERAL] unicode Mitja Novak
- [GENERAL] CREATE TABLE AS Chairudin Sentosa Harjo
- Re: [GENERAL] CREATE TABLE AS David Warnock