Hi,
I would like to write some administration plpgsql scripts that populate some
tables (dimension tables) and to execute them using psql. I’m not sure that is
possible with psql as it is with Oracle sqlplus or SQL Server MSQuery:
Oracle sqlplus:
---
DECLARE
V_MyObjectID bigint;
"Dean Gibson (DB Administrator)" <[EMAIL PROTECTED]> writes:
> So, given the fact that the right-hand-table is only about 15 rows, do
> you think changing the SELECT back to a LEFT JOIN, and then using a
> UNION to get the extra right-hand-rows in, is the best work-around?
Yeah, a UNION of left
On 2006-01-15 15:42, Tom Lane wrote:
EXPLAIN SELECT count(*) FROM "Extra" FULL JOIN "GeoRestrict" ON
callsign ~ pattern WHERE geo_region =
4;
Oh, but that reduces it to a left join, as you can see in the EXPLAIN
output ---
Yes, I previous
On 2006-01-15 15:21, Tom Lane wrote:
Really? The FULL JOIN condition using ~ is the source of the failure, and I'd
be quite surprised if changing WHERE makes it work.
Works fine:
EXPLAIN SELECT count(*) FROM "Extra" FULL JOIN "GeoRestrict" ON
callsign ~ pattern WHERE geo_region =
4;
"Dean Gibson (DB Administrator)" <[EMAIL PROTECTED]> writes:
> SELECT count(*) FROM "GenAppExtra" FULL JOIN "GeoRestrict" ON callsign
> ~ pattern WHERE region_id = 4 OR geo_region = 4;
> If either of the "region_id = 4" (a field in the right-hand table) or
> "geo_region = 4" (a field in the
On 2006-01-15 13:54, Michael Fuhr wrote:
What's the query?
SELECT count(*) FROM "GenAppExtra" FULL JOIN "GeoRestrict" ON callsign
~ pattern WHERE region_id = 4 OR geo_region = 4;
If either of the "region_id = 4" (a field in the right-hand table) or
"geo_region = 4" (a field in the le
Michael Fuhr <[EMAIL PROTECTED]> writes:
> The 8.0.5 Release Notes have the following item, but without seeing
> your query it's hard to know whether this fix is relevant to your
> problem (the fix mentions RIGHT JOIN; your error says FULL JOIN):
Good catch, but that bug was specific to left/right
"Dean Gibson (DB Administrator)" <[EMAIL PROTECTED]> writes:
> I have a FULL JOIN between two simple tables, and am getting the message
> " Query failed: ERROR: FULL JOIN is only supported with merge-joinable
> join conditions"
> I'd be glad to fix this in my query if I knew what the [EMAIL PRO
On Sun, Jan 15, 2006 at 12:25:10PM -0800, Dean Gibson (DB Administrator) wrote:
> I have a FULL JOIN between two simple tables, and am getting the message
> " Query failed: ERROR: FULL JOIN is only supported with merge-joinable
> join conditions"
>
> I'd be glad to fix this in my query if I kne
I have a FULL JOIN between two simple tables, and am getting the message
" Query failed: ERROR: FULL JOIN is only supported with merge-joinable
join conditions"
I'd be glad to fix this in my query if I knew what the [EMAIL PROTECTED] it meant.
Using 8.0.4 on FC1; willing to upgrade (Postgre
Thanks for reply Tom, but which docs should I read for that ?
Tom Lane escreveu:
> =?ISO-8859-1?Q?Alexandre_Gon=E7alves_Jacarand=E1?= <[EMAIL PROTECTED]> writes:
>
>>It's possible to make an SELECT inside an AS clause ?
>
>
> No. You could try building the query as a string.
>
>
Hello,
I created a table with a OID Column to carry the identifier for a Large
Object.
Now i want to run a trigger is the data of the large object has changed. To do
this I created an ON UPDATE-trigger on the table, but the trigger does get
fired if i only change the data of the large object (
12 matches
Mail list logo
