Re: Junk queries with variables?
От | Richard Huxton |
---|---|
Тема | Re: Junk queries with variables? |
Дата | |
Msg-id | 421D8F0B.1060409@archonet.com обсуждение исходный текст |
Ответ на | Junk queries with variables? ("Steve - DND" <postgres@digitalnothing.com>) |
Ответы |
Re: Junk queries with variables?
|
Список | pgsql-sql |
Steve - DND wrote: > I really have to be missing something here and this probably a *really* noob > question. I don't have a problem running little junk queries in the pgAdmin > query window(SELECT blah FROM blah, INSERT INTO blah, etc...), but I can't > figure out how to run queries with variables outside of a function. I just > want to use variables without having to go about creating and dropping a > function for every stupid little query I need to write. Example: > > amount int4 := 1000; > earliest_date timestamp := current_timestamp; Michael's given you one option - another to look at is PREPARE/EXECUTE PREPARE my_query(int4) AS INSERT INTO foo VALUES ($1); EXECUTE my_query(1); EXECUTE my_query(7); ... -- Richard Huxton Archonet Ltd
В списке pgsql-sql по дате отправления: