Junk queries with variables?
| От | Steve - DND |
|---|---|
| Тема | Junk queries with variables? |
| Дата | |
| Msg-id | LDEHKBBOEMIJKHKBOFNFGEEHLLAA.postgres@digitalnothing.com обсуждение исходный текст |
| Ответы |
Re: Junk queries with variables?
Re: Junk queries with variables? |
| Список | pgsql-sql |
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; SELECT ... I always get the error: "ERROR: syntax error at or near "amount" at character 1". What have I done wrong, or am I missing? Thanks, Steve
В списке pgsql-sql по дате отправления: