Skip site navigation (1) Skip section navigation (2)

Debugging question ...

From: Robert Bernabe <rbernabe(at)sandmansystems(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Debugging question ...
Date: 2007-11-08 03:56:38
Message-ID: 473288F6.8050000@sandmansystems.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi All,
I've been using MS SQL 2k and it's bundled query analyzer SQL editor for 
more than 5 years. I am exploring postgres right now and I hit a snag I 
don't understand...

MS SQL : debugging - use query analyzer, declare variables, plug in code 
and test...

PG : using PGAdminIII editor :

declare

tst int; (or whatever variable)

there is an error already....syntax error...

I did some research and it seems that variables cannot be declared 
outside a function scope? Looking at functions within PG, the 
implementation looks like one massive dynamic sql string....

I wanted to figure out how PG handles single quotes, double quotes, 
string concats and such.... problem is that the editor won't even let me 
declare variables...ahmm help? how does one debug in PG? what tool? 
anything like query analyzer of MS SQL? why can't I declare variables 
and print the values out to check and debug? HELP? Many Thanks in 
advance...

Responses

pgsql-novice by date

Next:From: Nico CallewaertDate: 2007-11-08 08:48:15
Subject: Trigger function syntax
Previous:From: G. J. WalshDate: 2007-11-07 22:05:44
Subject: client authentication - password encryption

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group