Hi,
Is the idea to use cursors as table sources good?
Do you plan to implement it in the future and if you plan will it be soon?
Regards,
Peter Filipov
--
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/
---(end of broa
om array in postgres.
Regards,
Peter Filipov
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
hi,
is there in postgres anything similar to:
insert on duplicate update?
here is the problem i need a solution for:
I need to insert in pg_type a row which was previously selected from there
and
with slight modifications, the problem is that when i try to insert the row
there might be a r
I figured out how to do it, myself. Just wondering why nobody answers me,
maybe I ask dumb questions
Cheers!
--
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/
---(end of broadcast)---
TIP 9: In versions below 8.0, the pl
This is what i can't get right:
CREATE type tst_tst as (a integer, b text);
CREATE OR REPLACE FUNCTION tst_store(a anyelement) RETURNS text AS $$
BEGIN
RETURN textin(record_out(a));
END
$$ LANGUAGE PLPGSQL;
create or replace function tst_load1(a text) returns tst_tst as $$
declare
Is there any way to covert an instance of a composite type to text,
to store it in a text column, and then to recreate the original object?
For example:
create type test as (a integer, b text);
create tble tstore (s text);
insert into tstore values((someproc((row(1, 'tst'))::test))::text);
selec
Q1: Can someone point me to documentation as to how to fully utilize the
object part (to say so)
of Postgres?
Q2: Will arrays of composite types be supported soon?
--
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/
---(end of broadcast)-
