Mon, 19 Nov 2012 09:31:17 +0800 -n
Craig Ringer <craig@2ndQuadrant.com> írta:
...
> In my opinion (a) would be horrible to use, and it appears to be
> contrary to the JDBC Resultset spec as well. You'd have to "double
> quote" every identifier if you wanted to use mixed case or any kind of
> non-alphanumeric strings, so:
>
> rs.getString("B.F. Name")
>
> would have to become:
>
> rs.getString("\"B.F. Name\"")
>
> or users would get syntax errors, identifier parsing errors, or
> bizarre errors about columns not being found.
>
> So (b) is the best compromise, really. Just alias your columns to
> disambiguate them in the result set by specifying `AS` aliases.
Craig! Thank you for the explanation!
I am to live with b...
Zsolt
