Hi
"outdated" packets is unfortunately a big issue on Debian. If you want
to have up-to-date apt-packages try
www.backports.org
Add one of the mirrors from the list to your sources.list, then run
apt-get update and then try to install again ...
:-) And you'll see, that you can install newer
O Jean-Paul Argudo έγραψε στις Mar 14, 2006 :
> Daniel Caune a ιcrit :
> > Wow, that was the quest for the Holy Grail! :-)
>
> Yes I understand. That kind of documentation for a
> contrib-addon-whatever for PostgreSQL can be tricky sometimes to find..
>
>
> I just jump on that thread to place a
Daniel Caune a écrit :
> Wow, that was the quest for the Holy Grail! :-)
Yes I understand. That kind of documentation for a
contrib-addon-whatever for PostgreSQL can be tricky sometimes to find..
I just jump on that thread to place a reminder for all those wanting to
implement trees in databases
On Mon, Mar 13, 2006 at 07:29:44PM -0500, Daniel Caune wrote:
> > > Replace "$libdir" by "/usr/lib/postgresql/8.1/lib/tablefunc.so" (I
> > > suggest to modifying only a copy of this file).
> >
> > That shouldn't be necessary unless the package installed the shared
> > objects somewhere other than
> -Message d'origine-
> De : Michael Fuhr [mailto:[EMAIL PROTECTED]
> Envoyé : lundi, mars 13, 2006 19:26
> À : Daniel Caune
> Cc : [EMAIL PROTECTED]; postgresql sql list
> Objet : Re: [SQL] connectby documentation
>
> On Mon, Mar 13, 2006 at 06:38:14PM -05
On Mon, Mar 13, 2006 at 06:38:14PM -0500, Daniel Caune wrote:
> I provide hereafter a description about how to install the function
> connectby (I didn't find such documentation and I don't know where to
> write this documentation):
README.tablefunc contains instructions on how to load the module
> > > Sorry, this is not my day: "apt-get install
postgresql-contrib-8.1"
> > > works fine... Just a link on the documentation that fully
explains
> how
> > > connectby() works would be great! :-)
> >
> > The contrib package should have installed a file named
> README.tablefunc.
> >
>
> You are
> > Sorry, this is not my day: "apt-get install postgresql-contrib-8.1"
> > works fine... Just a link on the documentation that fully explains
how
> > connectby() works would be great! :-)
>
> The contrib package should have installed a file named
README.tablefunc.
>
You are right. The documen
On Mon, Mar 13, 2006 at 04:56:39PM -0500, Daniel Caune wrote:
> Sorry, this is not my day: "apt-get install postgresql-contrib-8.1"
> works fine... Just a link on the documentation that fully explains how
> connectby() works would be great! :-)
The contrib package should have installed a file nam
> "outdated" packets is unfortunately a big issue on Debian. If you want
> to have up-to-date apt-packages try
>
> www.backports.org
>
> Add one of the mirrors from the list to your sources.list, then run
> apt-get update and then try to install again ...
> :-) And you'll see, that you can instal
7.4?! Huh... Is there any sources.list a bit more updated? Where can I
download PostgreSQL contrib modules. The documentation 8.1 doesn't help
so much. Where can I find more documentation on available contrib.
modules?
gentoo automatically compiles and installs the contribs (you just
> -Message d'origine-
> De : Michael Fuhr [mailto:[EMAIL PROTECTED]
> Envoyé : lundi, mars 13, 2006 11:12
> À : Daniel Caune
> Cc : postgresql sql list
> Objet : Re: [SQL] connectby documentation
>
> On Mon, Mar 13, 2006 at 10:37:37AM -0500, Daniel Caune wr
On Mon, Mar 13, 2006 at 10:37:37AM -0500, Daniel Caune wrote:
> I'm searching for an Oracle START WITH ... CONNECT BY PRIOR ...
> equivalence. It seems that PostgreSQL (version >= 7.4) supports a
> function connectby that provides similar feature. Unfortunately I don't
> find any documentation on
On Mon, Mar 28, 2005 at 02:02:32PM +0530, Chandan_Kumaraiah wrote:
>
> How do I write hierarchical queries in postgresql, which I would write
> using 'connectby' in oracle??
The contrib/tablefunc module has a connectby() function -- does it
do what you want?
--
Michael Fuhr
http://www.fuhr.org/~
I use postgresql 7.2.3
How can I use connectby ??
Must I install files ? or packages ? or it is recommanded to upgrade
dataserver ?
George Essig wrote:
hi
I have menu table:
id | integer | not null default
nextval('public.menu_id_seq'::text)
parent_id | integer |
> I use postgresql 7.2.3
> How can I use connectby ??
>
> Must I install files ? or packages ? or it is recommanded to upgrade dataserver ?
For recent versions of PostgreSQL, go into the contrib/tablefunc directory and see the
readme file
for how to install. I downloaded PostgreSQL 7.2.3 and the
BenLaKnet wrote:
I use postgresql 7.2.3
How can I use connectby ??
Must I install files ? or packages ? or it is recommanded to upgrade
dataserver ?
You need to upgrade. Either install 7.3.4 or wait a few weeks and
install 7.4 when it is released.
Joe
---(end of broadc
I use postgresql 7.2.3
How can I use connectby ??
Must I install files ? or packages ? or it is recommanded to upgrade
dataserver ?
George Essig wrote:
hi
I have menu table:
id | integer | not null default
nextval('public.menu_id_seq'::text)
parent_id | integer |
> hi
>
> I have menu table:
> id | integer | not null default
> nextval('public.menu_id_seq'::text)
> parent_id | integer |
> description | text|
>
> I do select:
> test=> SELECT * FROM connectby('menu','id','parent_id','2',0,'~') t(id
> integer, parent_id integer, level in
On Fri, 22 Nov 2002, Dan Langille wrote:
> Here is the actual data for the above nodes:
>
> freshports=# select * from element where id in (104503, 104504, 104505);
>id | name | parent_id | directory_file_flag | status
> +--+---+-+-
20 matches
Mail list logo
