row literal problem
| От | Andrew Dunstan |
|---|---|
| Тема | row literal problem |
| Дата | |
| Msg-id | 5007074E.7000308@dunslane.net обсуждение исходный текст |
| Ответы |
Re: row literal problem
|
| Список | pgsql-hackers |
I'm chasing up an issue from a client who has this problem (in 9.1):
with q as
( some query here
)
select q.* from q
yields:
job_scope | checked_col
-----------------------------------------------+------------------------------------------ Co Revenues: Co Revenues
$100to $999 Million | <input panel=data
type=checkbox checked> Metropolitan Area: Austin-Round Rock | <input panel=data
type=checkbox checked>
which is as expected.
However,
with q as
( same query here
)
select q from q
yields:
q
----------------------------------------------------------------------------------------------- ("Co Revenues: Co
Revenues$100 to $999 Million","<input panel=data
type=checkbox checked>",) ("Metropolitan Area: Austin-Round Rock","<input panel=data
type=checkbox checked>",)
Note the trailing comma inside the (), which certainly looks bogus to
me. If I replace "select q" with "select row(q.*)" it disappears.
It doesn't happen in all cases, and I'm trying to work out a minimal
reproducible example. But it sure is puzzling.
cheers
andrew
В списке pgsql-hackers по дате отправления: