some possible parser cleaning: drop support column(table) syntax

Started by Pavel Stehuleover 16 years ago8 messageshackers
Jump to latest
#1Pavel Stehule
pavel.stehule@gmail.com

Hello

this is syntax column(table) necessary still?

postgres=# select a(x) from x;
a
────
10
(1 row)

Regards
Pavel Stehule

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Pavel Stehule (#1)
Re: some possible parser cleaning: drop support column(table) syntax

Pavel Stehule <pavel.stehule@gmail.com> writes:

this is syntax column(table) necessary still?

There is no reason to remove that.

regards, tom lane

#3Pavel Stehule
pavel.stehule@gmail.com
In reply to: Tom Lane (#2)
Re: some possible parser cleaning: drop support column(table) syntax

2009/10/22 Tom Lane <tgl@sss.pgh.pa.us>:

Pavel Stehule <pavel.stehule@gmail.com> writes:

this is syntax column(table) necessary still?

There is no reason to remove that.

do you know somebody who use it? It is dead code. Processing of call
functions should be simpler.

Pavel

Show quoted text

                       regards, tom lane

#4Tom Lane
tgl@sss.pgh.pa.us
In reply to: Pavel Stehule (#3)
Re: some possible parser cleaning: drop support column(table) syntax

Pavel Stehule <pavel.stehule@gmail.com> writes:

2009/10/22 Tom Lane <tgl@sss.pgh.pa.us>:

Pavel Stehule <pavel.stehule@gmail.com> writes:

this is syntax column(table) necessary still?

There is no reason to remove that.

do you know somebody who use it? It is dead code.

It is not --- it's the recommended solution for emulating computed
columns. The column-as-f(x) direction maybe isn't terribly exciting,
but the function-as-x.col direction definitely is.

regards, tom lane

#5Robert Haas
robertmhaas@gmail.com
In reply to: Pavel Stehule (#3)
Re: some possible parser cleaning: drop support column(table) syntax

On Thu, Oct 22, 2009 at 10:22 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:

2009/10/22 Tom Lane <tgl@sss.pgh.pa.us>:

Pavel Stehule <pavel.stehule@gmail.com> writes:

this is syntax column(table) necessary still?

There is no reason to remove that.

do you know somebody who use it? It is dead code. Processing of call
functions should be simpler.

"Dead code" means code that can't actually be reached, not code that
does something you don't like. :-)

...Robert

#6Pavel Stehule
pavel.stehule@gmail.com
In reply to: Tom Lane (#4)
Re: some possible parser cleaning: drop support column(table) syntax

2009/10/22 Tom Lane <tgl@sss.pgh.pa.us>:

Pavel Stehule <pavel.stehule@gmail.com> writes:

2009/10/22 Tom Lane <tgl@sss.pgh.pa.us>:

Pavel Stehule <pavel.stehule@gmail.com> writes:

this is syntax column(table) necessary still?

There is no reason to remove that.

do you know somebody who use it? It is dead code.

It is not --- it's the recommended solution for emulating computed
columns.  The column-as-f(x) direction maybe isn't terribly exciting,
but the function-as-x.col direction definitely is.

is it documented?

regards
Pavel Stehule

Show quoted text

                       regards, tom lane

#7Tom Lane
tgl@sss.pgh.pa.us
In reply to: Pavel Stehule (#6)
Re: some possible parser cleaning: drop support column(table) syntax

Pavel Stehule <pavel.stehule@gmail.com> writes:

2009/10/22 Tom Lane <tgl@sss.pgh.pa.us>:

It is not --- it's the recommended solution for emulating computed
columns.  The column-as-f(x) direction maybe isn't terribly exciting,
but the function-as-x.col direction definitely is.

is it documented?

Yes, see "SQL Functions on Composite Types" (34.4.2 as of CVS HEAD),
down near the end of that subsection.

regards, tom lane

#8Pavel Stehule
pavel.stehule@gmail.com
In reply to: Tom Lane (#7)
Re: some possible parser cleaning: drop support column(table) syntax

2009/10/22 Tom Lane <tgl@sss.pgh.pa.us>:

Pavel Stehule <pavel.stehule@gmail.com> writes:

2009/10/22 Tom Lane <tgl@sss.pgh.pa.us>:

It is not --- it's the recommended solution for emulating computed
columns.  The column-as-f(x) direction maybe isn't terribly exciting,
but the function-as-x.col direction definitely is.

is it documented?

Yes, see "SQL Functions on Composite Types" (34.4.2 as of CVS HEAD),
down near the end of that subsection.

ok, thank you
Pavel

Show quoted text

                       regards, tom lane