Jan Wieck wrote:
Bruce Momjian wrote:
> Sounds good. I just think keywords in general are weird to use for
> quoting. We use "'" for quoting, so something similar like another
> operator combination would be nice. I have never been fond of the
> here-document approach, though I can see the value of doing
> here-documents in here-documents, though if we make the open and close
> of the quote string different <--, -->, we can still do that, no?
>
The beauty of here-documents is that you specify your closing tag on a per usage base and can vary that depending on the content you need to enclose. Keep in mind that this literal mechanism is not only used for PL/pgSQL, but for other languages like PL/Tcl and PL/Perl as well. Imagine the pain for a Tcl programmer if we'd go with curly braces!
Oh, non-SQL languages. OK, I agree, we need HERE documents, and I think we all agree it has to be done in the lexer.
Not only. psql by default sends the edit buffer when it encounters the ";". You don't want that to happen inside of the here document. So it has to duplicate that logic.
Jan
-- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== [EMAIL PROTECTED] #
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org