Re: SQL feature requests
От | Zeugswetter Andreas ADI SD |
---|---|
Тема | Re: SQL feature requests |
Дата | |
Msg-id | E1539E0ED7043848906A8FF995BDA579024F46A8@m0143.s-mxs.net обсуждение исходный текст |
Ответ на | Re: SQL feature requests (Michael Glaesemann <grzm@seespotcode.net>) |
Список | pgsql-hackers |
> > If your implementation accepts: > > > > group by case when true then 'foo' end I think he meant: group by case when true then "foo" end > > What would that mean? Regardless of whether or not it's accepted, it > should have *some* meaning. > > It's not equivalent to GROUP BY "foo" Yea, but only because 'foo' is an identifier, and not a string constant. > test=# select record_id as foo > , count(observation_id) as bar > from observation > group by case when true > then 'foo' > end; > ERROR: column "observation.record_id" must appear in the GROUP BY > clause or be used in an aggregate function I think your example would be easier to understand if you removed the quotes. We don't detect the correctness of the above query. You can hardly say that this is a feature, but I am not inclined to see it as a troublesome bug eighter. Andreas
В списке pgsql-hackers по дате отправления: