select into not supported within stored procedures?

#51

Zeljko Peric ha scritto:
[CUT]

Quote:

Postgres documentation says:
"The PostgreSQL usage of SELECT INTO to represent table creation is
historical. It is best to use CREATE TABLE AS for this purpose in new
code."

But if you need to work with record variables in your procedure, the
best way is to use rowtype or record type:

http://www.postgresql.org/docs/8.3/s...RATION-RECORDS

Thank you very much for the hint, it works inside a stored procedure, I
missed this statement on the documentation. Now I know that "create
table as" was added to the standard by SQL 2003:
http://en.wikipedia.org/wiki/SQL:2003

Quote:

You can collect %ROWTYPE into ARRAY if you need Table in you procedure.

I use record type for other purposes, "create table as" it is perfect
for me in this case

Thanks you again,
Anselmo Canfora

#52

Zeljko Peric ha scritto:
[CUT]

Quote:

Postgres documentation says:
"The PostgreSQL usage of SELECT INTO to represent table creation is
historical. It is best to use CREATE TABLE AS for this purpose in new
code."

But if you need to work with record variables in your procedure, the
best way is to use rowtype or record type:

http://www.postgresql.org/docs/8.3/s...RATION-RECORDS

Thank you very much for the hint, it works inside a stored procedure, I
missed this statement on the documentation. Now I know that "create
table as" was added to the standard by SQL 2003:
http://en.wikipedia.org/wiki/SQL:2003

Quote:

You can collect %ROWTYPE into ARRAY if you need Table in you procedure.

I use record type for other purposes, "create table as" it is perfect
for me in this case

Thanks you again,
Anselmo Canfora

#53

Zeljko Peric ha scritto:
[CUT]

Quote:

Postgres documentation says:
"The PostgreSQL usage of SELECT INTO to represent table creation is
historical. It is best to use CREATE TABLE AS for this purpose in new
code."

But if you need to work with record variables in your procedure, the
best way is to use rowtype or record type:

http://www.postgresql.org/docs/8.3/s...RATION-RECORDS

Thank you very much for the hint, it works inside a stored procedure, I
missed this statement on the documentation. Now I know that "create
table as" was added to the standard by SQL 2003:
http://en.wikipedia.org/wiki/SQL:2003

Quote:

You can collect %ROWTYPE into ARRAY if you need Table in you procedure.

I use record type for other purposes, "create table as" it is perfect
for me in this case

Thanks you again,
Anselmo Canfora

#54

Zeljko Peric ha scritto:
[CUT]

Quote:

Postgres documentation says:
"The PostgreSQL usage of SELECT INTO to represent table creation is
historical. It is best to use CREATE TABLE AS for this purpose in new
code."

But if you need to work with record variables in your procedure, the
best way is to use rowtype or record type:

http://www.postgresql.org/docs/8.3/s...RATION-RECORDS

Thank you very much for the hint, it works inside a stored procedure, I
missed this statement on the documentation. Now I know that "create
table as" was added to the standard by SQL 2003:
http://en.wikipedia.org/wiki/SQL:2003

Quote:

You can collect %ROWTYPE into ARRAY if you need Table in you procedure.

I use record type for other purposes, "create table as" it is perfect
for me in this case

Thanks you again,
Anselmo Canfora

#55

Zeljko Peric ha scritto:
[CUT]

Quote:

Postgres documentation says:
"The PostgreSQL usage of SELECT INTO to represent table creation is
historical. It is best to use CREATE TABLE AS for this purpose in new
code."

But if you need to work with record variables in your procedure, the
best way is to use rowtype or record type:

http://www.postgresql.org/docs/8.3/s...RATION-RECORDS

Thank you very much for the hint, it works inside a stored procedure, I
missed this statement on the documentation. Now I know that "create
table as" was added to the standard by SQL 2003:
http://en.wikipedia.org/wiki/SQL:2003

Quote:

You can collect %ROWTYPE into ARRAY if you need Table in you procedure.

I use record type for other purposes, "create table as" it is perfect
for me in this case

Thanks you again,
Anselmo Canfora

#56

Zeljko Peric ha scritto:
[CUT]

Quote:

Postgres documentation says:
"The PostgreSQL usage of SELECT INTO to represent table creation is
historical. It is best to use CREATE TABLE AS for this purpose in new
code."

But if you need to work with record variables in your procedure, the
best way is to use rowtype or record type:

http://www.postgresql.org/docs/8.3/s...RATION-RECORDS

Thank you very much for the hint, it works inside a stored procedure, I
missed this statement on the documentation. Now I know that "create
table as" was added to the standard by SQL 2003:
http://en.wikipedia.org/wiki/SQL:2003

Quote:

You can collect %ROWTYPE into ARRAY if you need Table in you procedure.

I use record type for other purposes, "create table as" it is perfect
for me in this case

Thanks you again,
Anselmo Canfora

#57

Zeljko Peric ha scritto:
[CUT]

Quote:

Postgres documentation says:
"The PostgreSQL usage of SELECT INTO to represent table creation is
historical. It is best to use CREATE TABLE AS for this purpose in new
code."

But if you need to work with record variables in your procedure, the
best way is to use rowtype or record type:

http://www.postgresql.org/docs/8.3/s...RATION-RECORDS

Thank you very much for the hint, it works inside a stored procedure, I
missed this statement on the documentation. Now I know that "create
table as" was added to the standard by SQL 2003:
http://en.wikipedia.org/wiki/SQL:2003

Quote:

You can collect %ROWTYPE into ARRAY if you need Table in you procedure.

I use record type for other purposes, "create table as" it is perfect
for me in this case

Thanks you again,
Anselmo Canfora