----- Цитат от Michael Giannakopoulos ([email protected]), на 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
