On Mon, Mar 10, 2008 at 9:20 PM, Kynn Jones <[EMAIL PROTECTED]> wrote:
> > > > Hi! When it comes to programming SQL, my newbie approach is to write my > code in a file test.sql, which I test from within psql by using > > my_db=> \i /some/path/test.sql > > ...and (once I'm satisfied with the code) copy and paste it to a different > file that has the SQL I've written so far for the project. > > It's a rather cumbersome system, all the more so because I don't have a > convenient way to comment out large chunks of code (which may include > C-style comments). > > I'm thinking of something like the trick of surrounding C code with pairs > of #if 0 and #endif, which effectively comments out code, even when it > contains /* C-style comments */. > > Is there some similar trick for SQL code? > If your sole objective is to comment out large chunks of SQL code, which in turn may have multi-line comments, then the simplest trick is to comment them using /* multi-line */ itself! The SQL standard, and Postgres, allow you to nest comments; some commercial RDBMS' do not provide this, and hence people think it's not possible in SQL. So following is possible, and you can \include this file in psql with your desired results: /* temporary big comment to test only one query, and ignore others /* my first query */ select 'hello world'; /* my second query */ select 200*201; /* my application's query */ select ename from emp where empid = 10; end big comment */ /* Currently testing this query, and do not want the above queries to be executed until I am finished with this. So, put everything above this comment in a huge multi-line comment */ select ename, dname from emp, dept where emp.deptid = dept.deptid; -- [EMAIL PROTECTED] [EMAIL PROTECTED] gmail | hotmail | indiatimes | yahoo }.com EnterpriseDB http://www.enterprisedb.com 17° 29' 34.37"N, 78° 30' 59.76"E - Hyderabad * 18° 32' 57.25"N, 73° 56' 25.42"E - Pune 37° 47' 19.72"N, 122° 24' 1.69" W - San Francisco http://gurjeet.frihost.net Mail sent from my BlackLaptop device
