Ross J. Reedstrom wrote:
Finaly, a table to allow a many to many join called files_folders
| files_folders
x| ffid
| folderid (fk to folders.folderid)
| fileid (fk to files.fileid)
Strange. Do you need this table? Can one file exist in several
directories?
If not, you can just
On Wed, Jan 15, 2003 at 03:19:38PM -0500, Matthew Nuzum wrote:
> > -Original Message-
> > From: Tomasz Myrta [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, January 15, 2003 3:00 PM
> > To: Matthew Nuzum
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: [SQ
On Wed, Jan 15, 2003 at 13:29:47 -0500,
Matthew Nuzum <[EMAIL PROTECTED]> wrote:
>
> Can anyone suggest a way for me to get the information I need? I'm very
> content to use a simple pl/pgsql function, however I don't know how I'd
> use recursion there.
Look at the tablefunc contrib package. I
> -Original Message-
> From: Tomasz Myrta [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 15, 2003 3:00 PM
> To: Matthew Nuzum
> Cc: [EMAIL PROTECTED]
> Subject: Re: [SQL] lost on self joins
> >Finaly, a table to allow a many to many join called files_fol
Matthew Nuzum wrote:
Sometimes recursion makes my head spin...
Imagine that I have a database that holds the structure of my
filesystem. There is a table called files that contains every piece of
info you would ever want to know about a file, including a unique ID
called fileid.
| files
===
Sometimes recursion makes my head spin...
Imagine that I have a database that holds the structure of my
filesystem. There is a table called files that contains every piece of
info you would ever want to know about a file, including a unique ID
called fileid.
| files
x| fileid
| filenam
