Re: Parser - Query Analyser - Mailing list pgsql-hackers

From Любен Каравелов
Subject Re: Parser - Query Analyser
Date
Msg-id 6b1a60652e2cca0b4ed037359f059dbc.mailbg@mail.bg
Whole thread Raw
In response to Parser - Query Analyser  (Michael Giannakopoulos <miccagiann@gmail.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Materialized views WIP patch
Next
From: Andres Freund
Date:
Subject: Re: foreign key locks