In pgadmins SQL-window SQL is the 'language' of choice. Or it is rather the only language. Thus if you intend to program plTk or PL/pgSQL, there's no way around defining a function.
(At first you have to define a new language in your schema) C:\> -----Original Message----- C:\> From: Steve - DND [mailto:[EMAIL PROTECTED] C:\> Sent: Donnerstag, 24. Februar 2005 07:13 C:\> To: pgsql-sql@postgresql.org C:\> Subject: [SQL] Junk queries with variables? C:\> C:\> C:\> I really have to be missing something here and this C:\> probably a *really* noob C:\> question. I don't have a problem running little junk C:\> queries in the pgAdmin C:\> query window(SELECT blah FROM blah, INSERT INTO blah, C:\> etc...), but I can't C:\> figure out how to run queries with variables outside of a C:\> function. I just C:\> want to use variables without having to go about creating C:\> and dropping a C:\> function for every stupid little query I need to write. Example: C:\> C:\> amount int4 := 1000; C:\> earliest_date timestamp := current_timestamp; C:\> C:\> SELECT ... C:\> C:\> I always get the error: "ERROR: syntax error at or near C:\> "amount" at C:\> character 1". What have I done wrong, or am I missing? C:\> C:\> Thanks, C:\> Steve C:\> C:\> C:\> C:\> ---------------------------(end of C:\> broadcast)--------------------------- C:\> TIP 9: the planner will ignore your desire to choose an C:\> index scan if your C:\> joining column's datatypes do not match C:\> ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
