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 по дате отправления: