Re: [HACKERS] can we enhance regtype infunction to support %type and %type[]
Pavel Stehule pavel.steh...@gmail.com writes: I am looking on ToDo topic - Allow handling of %TYPE arrays, e.g. tab.col%TYPE[] Some the most simple solution can be enhancing regtype to support this syntax I'm not really in favor of adding a wart like that to regtype, and I don't see how it would do anything to advance the TODO item anyway. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] can we enhance regtype infunction to support %type and %type[]
2010/9/4 Tom Lane t...@sss.pgh.pa.us: Pavel Stehule pavel.steh...@gmail.com writes: I am looking on ToDo topic - Allow handling of %TYPE arrays, e.g. tab.col%TYPE[] Some the most simple solution can be enhancing regtype to support this syntax I'm not really in favor of adding a wart like that to regtype, and I don't see how it would do anything to advance the TODO item anyway. it can reduce a duplicate code - it is used on PL level and on PLpgSQL. and be very useful as protection to SQL injection, where you have to check if some table has some column. Regards Pavel Stehule regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
[HACKERS] can we enhance regtype infunction to support %type and %type[]
Hello I am looking on ToDo topic - Allow handling of %TYPE arrays, e.g. tab.col%TYPE[] Some the most simple solution can be enhancing regtype to support this syntax - this can be relative simple, and it can be useful for other PL and for dynamic SQL too. It can be simple test - if some table has a column or not. comments? Regards Pavel Stehule -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
