gt; --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
William Leite Araújo
Pai 0.6 beta 2.1 "Dizem que agora melhora..."
m just
> a beginner to
> this.
>
> Thanks in advance,
> Aravind.
>
>
>
>
>
> I have written a python program that may help you.
>
> It is part of a larger project I hope to post in a few days.
>
> Or I could sent it to you.
>
> Gwyneth
>
--
William Leite Araújo
Pai 0.6 beta 2.1 "Dizem que agora melhora..."
r*
>
> Lean Back and Relax - Enjoy some Nature Photography:
> http://photoblog.la-famille-schwarzer.de
>
> Appetite for Global Data? UNEP GEP Data Portal:
> http://geodata.grid.unep.ch
>
>
>
>
>
>
>
--
William Leite Araújo
Estudante de paternidade - 24a semana
onnections:
hostall all ::1/128 trust
I could be wrong. Please help the newb.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
--
William Leite Araújo
Estudante de paternidade - 13a semana
ent from the PostgreSQL - general mailing list archive at Nabble.com.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
--
William Leite Araújo
Analista de Banco de Dados - QualiConsult
with colulmn_y
would do it?
Thanks,
~Harpreet
--
William Leite Araújo
Analista de Banco de Dados - QualiConsult
(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
--
William Leite Araújo
Analista de Banco de Dados - QualiConsult
e
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
--
William Leite Araújo
Analista de Banco de Dados - QualiConsult
ed". When it *was*provided*, but its value was NULL, the VIEW
behaves differently then the TABLE.
Is there a way, to make such VIEW behave *exactly* as the TABLE does?
--
-R
---(end of broadcast)-------
TIP 2: Don't 'kill -9' the postmaster
--
William Leite Araújo
Analista de Banco de Dados - QualiConsult
r list archives?
http://archives.postgresql.org/
--
William Leite Araújo
Analista de Banco de Dados - QualiConsulte
-10-31':: DATE);In real queries I have column names and parameters instead of dataconstants.The only way it seems to replace OVERLAPS operator with AND, OR, <=
operators.Is it so ?Andrus. Maybe: ('2006-10-16'::DATE BETWEEN '2006-10-30'::date AND '-12-31'::date) OR ('2006-10-31'::DATE BETWEEN '2006-10-30'::date AND '-12-31'::date)
-- William Leite Araújo
2006/11/7, Alain Roger <[EMAIL PROTECTED]>:
but there is already a RETURN NEXT res;so what will be the point of this RETURN after the END LOOP; ?http://www.postgresql.org/docs/8.1/interactive/plpgsql-control-structures.html
-- William Leite Araújo
RN NEXT res; END LOOP;
RETURN; END;$body$LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;
Never forgot of return before "END" procedure;-- William Leite Araújo
.famundo.com - coming soon!
My development related blog: http://devblog.famundo.com---(end of broadcast)---TIP 6: explain analyze is your friend
-- William Leite Araújo
plex function with 65 arguments, but when I try torun it I get an error complaining that arguments can be up to 32.
Is there a way to solve this problem or do I have to try to split thefunction into three new ones?--Non c'e' piu' forza nella normalita', c'e' solo monotonia.
-- William Leite Araújo
string containing comma-separated values (orthe array definition) and use that.
-- Richard Huxton Archonet Ltd---(end of broadcast)---TIP 5: don't forget to increase your free space map settings
-- William Leite Araújo
Maybe pg_trgm contrib.-- William Leite Araújo
type "setof"?
-- William Leite Araújo
2006/5/25, Brandon E Hofmann <[EMAIL PROTECTED]>:
(..)I tried defining composite types, but get a runtime error that it isn'tavailable. That is you postgres-- William Leite AraújoEspecialista em Geoprocessamento- UFMG
Bacharel em Ciêncida da Computação - UFMGMSN: [EMAIL PROTECTED]ICQ:2
On 4/17/06, Tom Lane <[EMAIL PROTECTED]> wrote:
[EMAIL PROTECTED] writes:> I'm trying to write a stored procedure that can capture all the changes> to a table and record the changes based on the table's primary key.
> I can almost get there but the sticking point is being able to access> the primar
-
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-- William Leite Araújo
-(end of broadcast)---TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to
[EMAIL PROTECTED] so that your message can get through to the mailing list cleanly-- William Leite Araújo
TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
-- William Leite Araújo
I have 2 tables, A and B. Onde update on A fires a trigger "Ta" that insert by "dblink_exec" on B. B has an insert trigger "Tb" that print a message before line "RETURN NEW;" command of "Tb", but "Ta" call to "dblink_exec"
c (GCC) 3.3.5 (Debian 1:3.3.5-13))!
I build a temp table using various select statements and then try to
return the result as a recordset. I get an error: type t1 does not exist. Please, send the sample. I test "Create temp table AS SELECT * FROM " and works on
8.0.6-- William Leite Araújo
Hi all, Anyone has or knows a function to manipulate/work with int2vector type? Tank's-- William Leite Araújo
greSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.5 (Debian 1:3.3.5-5)
Any idea?
-- William Leite Araújo
rent of "CREATE TABLE as SELECT * FROM schema.table" please.-- William Leite Araújo
trouble, because the
return of functions "slice_from_s" and "slice_del" are "int" in current
snowball portuguese files, but on include files of version 8.0.2 and
8.0.3 of Portgresql the return type is "void".
Help-me, please.
-- William Leite Araújo
29 matches
Mail list logo
