Re: Parser - Query Analyser

----- Цитат от Michael Giannakopoulos (miccagiann(at)gmail(dot)com), на 17.11.2012 в 16:18 -----

> Hello guys,
>
> My name is Michail Giannakopoulos and I am a graduate student at University
> of Toronto. I have no previous experience in developing a system like
> postgreSQL before.
>
> What I am trying to explore is if it is possible to extend postgreSQL in
> order to accept queries of the form:
>
> Select function(att1, att2, att3) AS output(out1, out2, ..., outk) FROM
> [database_name];
>

Why invent non-standard syntax for something that you could do in SQL.

You could try something like this:

SELECT
(m.f).f_out_name1 AS out1,
(m.f).f_out_name2 AS out2,
(m.f).f_out_name3 AS out3
FROM (
SELECT f(att1,att2,att3) FROM input_table_name
) AS m;

Best regards

--
Luben Karavelov