"Dave Cramer" <[EMAIL PROTECTED]> writes: > I tried it on a table which id was an int > Using "select 'id' as xxx from ..." Returns xxx as an unknown type > Using "select id as xxx from... " returns xxx as an int > I have no idea how the backend handles this, but if it can figure it out > in one instance why can't it figure it out when I put single quotes > around it?
Uh ... when you put single quotes around it, it's a literal, not a column reference ... and whatever one might think about 'id', it's certainly not an integer. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org