Hi, there,
I don't quit sure what you really want to solve, however,
if you use EXCEPT results1 and result2 should be same type rather than
tables, i.e.
select a,b from tab1
except
select c,d from tab2;
a,c are same type
b,d are same type.
notes, EXCEPT to big table is not efficient, so does IN
Hi,
I tried the write up the following SQL statement:
result1 from sql1 = (1,2,3,4,5)
result2 from sql2 = (4,5)
result3 = result1/result2 (or is it result2/result1) = (1,2,3)
What do I have to do to get the (1,2,3) result? I tried "query EXCEPT
query", but it seems like EXCEPT needs both table
Hi,
I want drop some tables, is there any way to get the info which
can show when the tables were used last time?
I mean that I want know when this table is used last time?
--
Jie LIANG
Internet Products Inc.
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
[EM
>
>Then I have read the POSTGRES on SOLARIS and other
>FAQ's and then edited the /etc/system file and added
>the following entries to increase the shared memory
>size to 128MB.
>
>
>set shmsys:shminfo_shmmax=268435456
>set shmsys:shminfo_shmmin=200
>set shmsys:shminfo_shmmni=200
>set shmsy
Dear All,
I have installed postgres 7.0.2 on solaris 7 on an
intel based machine. But, when I am trying to run the
postmaster( the database startup) with minimum buffers
also it gives the following error
IpcMemoryCreate: shmget failed (Invalid argument)
key=5432001, size=1104
