PHP Developers Network

This is driving me nuts, can't see the problem here.

Here is my table definition
SQL
error in phpPgAdmin

SQL error:

ERROR: syntax error at or near "INTO"
LINE 1: SELECT COUNT(*) AS total FROM (INSERT INTO custwelc_section ...
^

In statement:
SELECT COUNT(*) AS total FROM (INSERT INTO custwelc_section (owner, sheader, scontent) VALUES (5, 'about me', 'vvvvvvvvvvvvvvvvv')) AS sub

I don't think you can use an INSERT as a sub-select. Maybe try:

GET DIAGNOSTICS integer_var = ROW_COUNT;

I didn't use it as a subselect, that's just how is is displayed in the error. All I entered was the insert statement as shown.

It's working now, and the only thing I did was try it in pgadmin