Re: Import: empty string and expression

From: Quan Zongliang <quanzongliang(at)gmail(dot)com>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Import: empty string and expression
Date: 2009-02-26 09:17:57
Message-ID: 20090226180116.3B87.4125B4E5@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

> Right - so why do we need to escape anything in the expression?
> Shouldn't the user just be able to free-type whatever they want (in
> the same way they would if they were writing the expression as part of
> a query in the Query Tool?
I have to convert column names in expression to data for every row
before generate statement. Without escape char, I don't know
what is column-name, what is lexical. Once the user want to input
a lexical same as one of column-names, confusion occur.

For example, with CSV row "A1,B1,C1,D1":
'Column #1' || <Column #3> will be converted to 'Column #1' || 'C1'
The first is a lexical, the second is CSV column.

But 'Column #1' || Column #3 can't be converted properly.

-----------------------------------------------
Quan Zongliang
quanzongliang(at)gmail(dot)com
CIT Japan: http://www.cit.co.jp
CIT China: http://www.citbj.com.cn

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2009-02-26 09:32:46 Re: Import: empty string and expression
Previous Message Dave Page 2009-02-26 09:06:13 Re: Import: empty string and expression