On Sat, August 16, 2008 15:55, Mickael Deloison wrote: > 2008/8/14 Erikjan Rijkers <[EMAIL PROTECTED]>: >> 1) It would be nice if pgScript would only execute a select-block, like the >> normal pgAdmin querytool does. > > Do you mean: redirecting a pgScript script to the regular query tool > if both the pgScript button is pressed and the edit window contains > only a select statement?
No. In the regular query tool one can draw a select block (with mouse or keyboard). Subsequently pressing F5 *only* executes the selected text. This is a very handy behaviour that (I think) could be mimicked by pgscript without problem. (it makes it easy to quickly test parts of a larger script.) >> 2) The example script from the url above says: >> IF (SELECT 1 FROM table) -- Then table exists > You're right, with a count(*) it returns something (0 if no rows) and > this is true. Right, thanks. >> 3) When the BEGIN - END block fails, pgScript executes the ELSE block. >> This >> seems questionable behaviour, no? It can be seen with that same > I do not understand this observation. Could you be more precise please? Upon consideration, I might have been mistaken; I'll test again and look for a clearly reproducible case. thanks, Erikjan -- Sent via pgadmin-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
