This is a very basic syntax issue. You are starting the variable with
query := 'SELECT... with a single quote. The variable is then finished because of the single quote at
...(tc.constraint_type)='foreign key... (the single quote before foreign key). You need to add an additional single quote so it looks like this:
.... (tc.constraint_type)=''foreign key'' OR.... This will ensure your string is not broken and that a valid SELECT statement is generated. See:
36.2. Tips for Developing in PL/pgSQL —
hot2use 1 min ago
This is giving me an error. Any help or clues?
ERROR: syntax error at or near "foreign"
LINE 19: where lower(tc.constraint_type)='foreign key' OR lower(tc.co...
Here is my code:
create or replace function
help_constraint(schemaname text, tablename text) returns char
as
$body$
declare...
What features of Stack Exchange sites do you consider "hidden"?
Yes there will be a (marginal) impact on performance, but if it's for debugging purposes I don't think you'll be able to tell the difference.
You can easily test this yourself on your data by adding statistics IO and looking at the query plans
Take this code for example:
SET STATISTICS time ON...
At some point this afternoon the edit comment functionality was changed and now when you edit a comment you see [object Object] instead of the text. If I click edit here:
I see this:
This is happening on at least Database Administrators and Stack Overflow.
I am writing a query that returns a single record from the parent table. I would like to also return in this query if it has any children. This is a one to many relationship.
parent:
-parent_id
-name
child:
-child_id
-name
-parent_id
My first instinct is to write the following query:
selec...
