SQL function problem in 7.1?
| От | Richard Huxton |
|---|---|
| Тема | SQL function problem in 7.1? |
| Дата | |
| Msg-id | 002f01c092aa$4e10e6c0$1001a8c0@archonet.com обсуждение исходный текст |
| Ответы |
Re: SQL function problem in 7.1?
|
| Список | pgsql-general |
Am I doing something stupid with strings in SQL functions.
richardh=> select version();
version
------------------------------------------------------------------------
PostgreSQL 7.1beta3 on i586-pc-linux-gnu, compiled by GCC egcs-2.91.66
(1 row)
richardh=> select * from foo;
a | b
---+-----
1 | aaa
2 | bbb
3 | ccc
(3 rows)
richardh=> create function fooa(int) returns text as 'select b from foo
where a = $1;' language 'sql';
CREATE
richardh=> select fooa(2);
fooa
------
bbb
(1 row)
richardh=> create function foob(text) returns int as 'select a from foo
where b = ''$1'';' language 'sql';
CREATE
richardh=> select foob('bbb');
foob
------
(1 row)
TIA
- Richard Huxton
В списке pgsql-general по дате отправления: