ISO something like "#if 0 ... #endif" for SQL code
От | Kynn Jones |
---|---|
Тема | ISO something like "#if 0 ... #endif" for SQL code |
Дата | |
Msg-id | c2350ba40803100850u670a9cc9tf630f65c1e63b847@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: ISO something like "#if 0 ... #endif" for SQL code
Re: ISO something like "#if 0 ... #endif" for SQL code Re: ISO something like "#if 0 ... #endif" for SQL code Re: ISO something like "#if 0 ... #endif" for SQL code |
Список | pgsql-general |
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?
TIA!
Kynn
В списке pgsql-general по дате отправления: