Inserting a constant along with field values.
От | Pól Ua Laoínecháin |
---|---|
Тема | Inserting a constant along with field values. |
Дата | |
Msg-id | CAF4RT5RHkUt9rXkU7wTgjzw-i9Ten14Vm-8StDR6TDsxKN9nKg@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Inserting a constant along with field values.
|
Список | pgsql-novice |
Hi all, I'm pondering an issue which has arisen. Suppose I have a query of the type: SELECT x.f1, x.f2, .. x.fn, y.f1, y.f2, .. y.fn, COUNT(z.id) FROM xtab x JOIN ytab y ON x.x_key = y.y_key JOIN ztab z ON z.z_key = y._other_key Now, what I would like to do is to put the COUNT(z.id) into a CTE and then essentially SELECT a constant value into that part of the query WITH cte AS ( SELECT COUNT(z.id) AS zcnt FROM z ) SELECT x.fields, y.fields, c.zcnt FROM xtab x JOIN ytab y ON x.x_key = y.y_key JOIN cte c ON ....... And it's here that I'm stuck. I just can't figure out how to get the constant value into the result set. I keep getting messages like "unknown column 'p.pcnt'". Any ideas, references &c appreciated! TIA and g
В списке pgsql-novice по дате отправления: