On Friday 01 October 2010 6:54:09 am Alexander Farber wrote: > How do you copy a column from table please? > I'm trying with PostgreSQL 8.1.21/CentOS 5.5: > > # psql -a -f clean-forum.sql > start transaction; > START TRANSACTION > create temp table old_topics (topic_id integer) on commit delete rows; > CREATE TABLE > create temp table old_posts (post_id integer) on commit delete rows; > CREATE TABLE > select topic_id from phpbb_topics where forum_id=5 and topic_poster=1 > and age(to_timestamp(topic_time))>interval '14 days' into old_topics; > psql:clean-forum.sql:6: ERROR: syntax error at or near "into" at character > 124 psql:clean-forum.sql:6: LINE 1: ... > age(to_timestamp(topic_time))>interval '14 days' into old_t... > psql:clean-forum.sql:6: > ^ > commit > ROLLBACK > > Of course "select ... into" doesn't work, but how should I do it? > Can't find in http://www.postgresql.org/docs/8.1/static/ > > Thank you > Alex http://www.postgresql.org/docs/8.1/interactive/sql-insert.html -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
