}
if (PGG(default_link) != id) {
PGG(default_link) = id;
zend_list_addref(id);
}
}
-
Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio
On Sun, 18 Feb 2001, Bruce Momjian wrote:
> [ Charset ISO-8859-1 unsupported, converti
This is the closest thing to what you want:
GRANT ALL ON table TO user;
(see http://www.postgresql.org/users-lounge/docs/7.0/user/sql-grant.htm)
Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio
On Wed, 31 Jan 2001, Martin A. Marques wrote:
> El Mar 30
OTICE: QUERY PLAN:
Index Scan using idxtest on test (cost=0.00..2.01 rows=1 width=4)
EXPLAIN
testdb=# explain select * from test where col = func_test(1);
NOTICE: QUERY PLAN:
Seq Scan on test (cost=0.00..100.00 rows=1 width=4)
EXPLAIN
Michael Fork - CCNA - MCP - A+
Network Support
Here's the query that, given the primary key table, lists all foreign
keys, their tables, the RI type, and defereability.
Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio
SELECT pg_trigger.tgargs,
pg_trigger.tgnargs,
pg_trigger.tgdefer
the foreign keys and primary keys and tables, you must parse the
null-terminated pg.tgargs.
When I get the equivalent query working for primary keys I will send it
your way -- or if you beat me to it, send it my way (I am working on some
missing functionality from the ODBC driver)
Michael Fork
his to make sense in the future (who knows,
maybe next they will implement RS returning SP's or clusters, projects
that are funded with their profit off the advanced replication and
distributed information capabilities that they *may* withhold -- would
people still be whining then?)
Michael For
AND pg_proc.oid = pg_trigger.tgfoid
AND pg_trigger_1.tgfoid = pg_proc_1.oid
AND pg_trigger_1.tgconstrrelid = pc.oid
AND ((pc.relname='tblmidterm')
AND (pp.proname LIKE '%ins')
AND (pg_proc.proname LIKE '%upd')
AND (pg_proc_1.proname LIKE '%del'))
Michae
ne that is used depends on what the user puts
in the REFERENCES line.
Am I correct?
Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio
On Fri, 1 Dec 2000, Stephan Szabo wrote:
>
> It's representing a single null I believe. I'm not
> sure i
I am curious as to where the newest ODBC driver source is -- I retrieved
/src/interfaces/odbc from CVS, but it appeared to only be version
6.40.0009 and was lacking the Visual C++ workspace/project files that
were in the 6.50. release zip file on the FTP server.
Thanks
Michael Fork - CCNA
foreign key
primary_int_1\000 -- 1st field in referenced primary key
foreign_int_2\000 -- 1st field in foreign key
primary_int_2\000 -- 1st field in referenced primary key
Thanks
Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio
try this
SELECT age(max(h_date), now()) FROM table WHERE email='hawks@vsnl';
Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio
On Thu, 30 Nov 2000, Manish Vig wrote:
> Dear Sir,
> thanks for the reply.
> I tried se
Thought this may be of interest to some...
http://www.phpbuilder.com/columns/tim20001112.php3
Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio
-
play_id | int4| not null default nextval('...
play_online | bool| default 'f'
play_name | varchar(30) | not null
play_username | varchar(16) | not null
play_password | varchar(16) | not null
which is incorrect accoring to the initial query. It appears to be
ordering the individual selects and then appending the second query to
the first -- is this correct?
Thanks
Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio
some limitations, and two of the relations used are views, so I
belive that that may be the problem, but I want to be sure...
Thanks
Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio
football=# SELECT play.play_id as play_id, year.correct_picks
as
14 matches
Mail list logo
