--- On Wed, 12/26/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > but i do not want use function or procedure
Are you sure? I thought that: DECLARE IF --control structures @@rowcount where only usable in a store procedure. Am I incorrect, or are these keywords accessible from the SQL prompt? Regards, Richard Broersma Jr. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org