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
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 |