Hello.
Why is it that my index for text[] data type is not recognized by the
Planner?
I did these steps:
1. create function textarr(text[]) returns text language sql as 'select
$1[1]' strict immutable
2. create index org_idx on EmpData (textarr(org));
3. vacuum full
4. explain analyze select na
I can put all the other constaints deferrable, but the *NOT NULL* one
seems to be undeferrable.
Is ther a way to by-pass this or is do you know if this is planned in
the future versions?
--
Ci-git une signature avortee.
** RIP **
---(end of broadcast)
Dnia 2003-12-05 13:43, Użytkownik Kumar napisał:
Why is it so. Cant I use 'INTO [variable_name]' inside a dynamic query.
Please shed some light.
Well, you didn't read the manual, did you?
9.5.4. Executing dynamic queries
"the only way to extract a result from a dynamically-created SELECT is
to
Dear Friends,
I am using postgres 7.3.4 running on RH Linux 7.2. While
writing dynamic SQL stmts, i have the following problem. Using cursor works
fine.
OPEN ref FOR
EXECUTE \'SELECT comma(full_name) FROM (SELECT
usr.full_name FROM project_members,users usr
WHERE project_members.pro
