Re: Parser - Query Analyser

Поиск
Список
Период
Сортировка
От Любен Каравелов
Тема Re: Parser - Query Analyser
Дата
Msg-id 6b1a60652e2cca0b4ed037359f059dbc.mailbg@mail.bg
обсуждение исходный текст
Ответ на Parser - Query Analyser  (Michael Giannakopoulos <miccagiann@gmail.com>)
Список pgsql-hackers
----- Цитат от Michael Giannakopoulos (miccagiann@gmail.com), на 17.11.2012 в 16:18 -----<br /><br />> Hello
guys,<br/>> <br />> My name is Michail Giannakopoulos and I am a graduate student at University<br />> of
Toronto.I have no previous experience in developing a system like<br />> postgreSQL before.<br />> <br />>
WhatI am trying to explore is if it is possible to extend postgreSQL in<br />> order to accept queries of the
form:<br/>> <br />> Select function(att1, att2, att3) AS output(out1, out2, ..., outk) FROM<br />>
[database_name];<br/>> <br /><br />Why invent non-standard syntax for something that you could do in SQL. <br /><br
/>Youcould try something like this:<br /><br />SELECT<br /> (m.f).f_out_name1 AS out1,<br /> (m.f).f_out_name2 AS
out2,<br/> (m.f).f_out_name3 AS out3<br />FROM (<br /> SELECT f(att1,att2,att3) FROM input_table_name<br />) AS m;<br
/><br/>Best regards<br /><br />--<br />Luben Karavelov 

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Materialized views WIP patch
Следующее
От: Andres Freund
Дата:
Сообщение: Re: foreign key locks