[SQL] [postgres] Text zu bytea casten

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hallo, ich habe in einer Tabelle eine Spalte mit dem Datentyp text, das ich nach bytea wandeln möchte (um später auch \000 speichern zu können). Direkt scheint ein Alter Table da nicht zu gehen, also lege ich eine temporäre Spalte an. Nur: > UPDA

Re: [SQL] [postgres] Deutsche PostgreSQL-Mailingliste unter

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 - -- Peter Eisentraut <[EMAIL PROTECTED]> wrote: > Was haltet ihr also davon, die ganze Operation dorthin zu verlegen? ja, da bin ich eindeutig dafür. Dies dürfte auch den positiven Nebeneffekt haben, dass hier etwas mehr los ist und interessierte

Re: [SQL] [postgres] PostgreSQL-DB auf Web-Schnittstelle bringen

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hallo, - -- Ian Barwick <[EMAIL PROTECTED]> wrote: > Fuer diese Aufgabe wuerde sich eignen z.B. phpPgAdmin: > http://phppgadmin.sourceforge.net/ vor einiger Zeit hatte ich mir das mal angeschaut -- und fand das nur grauselig. OK, besser als nichts.

Re: [SQL] [postgres] PostgreSQL-DB auf Web-Schnittstelle bringen

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 - -- [EMAIL PROTECTED] wrote: > Welches Verfahren/Vorgehen würdet Ihr mir denn empfehlen, wenn ich eine > PostgreSQL- Datenbank auf eine Web-Schnittstelle bringen will? was meinst Du denn damit genau? Du hast irgendeine Applikation die ihre Daten

Re: [SQL] [postgres] Antwort von Microsoft auf Mail hier!

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 - -- Danny Tramnitzke <[EMAIL PROTECTED]> wrote: > da ist wohl was zwischen MS und Yahoo im Busch ... die Frage ist, inwieweit das bekannt gegeben ist, ob das geheim abläuft usw. Wenn da entsprechendes der Fall sein sollte, sehe ich das durchaus

[SQL] [postgres] Antwort von Microsoft auf Mail hier!

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hallo allerseits, wer hat denn Zugriff auf die Subscriber-Liste dieser Liste? Eben bekam ich auf meine Mail oben eine Antwort von *Microsoft*. Der Inhalt unten. Also, entweder ist da jemand offiziell eingetragen, oder hat einen Deal mit Yahoogroups

Re: [SQL] [postgres] Foreign Key

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hallo, - -- Stefan Sturm <[EMAIL PROTECTED]> wrote: > Ich tippe mal, das der PostgreSQL Manager da selber ein Timeout macht. > Habe es auch mal mit phpPgAdmin versucht. Der läuft sich Tod. Ist die Tabelle groß? Da kann es natürlich sein, dass da ein

Re: [SQL] [postgres] Foreign Key

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hallo, - -- Stefan Sturm <[EMAIL PROTECTED]> wrote: > In der Tabelle status befinden sich Datensätze. Die Tabelle logins ist > leer. Nun versuche ich folgenden Befehl: > > ALTER TABLE "public"."login " ADD CONSTRAINT "test" FOREIGN KEY > ("status__i

Re: [SQL] 2 Selects 1 is faster, why?

Hi, -- Eric <[EMAIL PROTECTED]> wrote: > If I perform the following 2 selects, the first one is EXTREMELY slow > where the 2nd one is very fast. [...] > Why would 2 be so much faster? I have ran the EXPLAIN on this and index > scans are being used. I guess, the first query has to search for

Re: [SQL] Returning multiple Rows from PL/pgSQL-Function

Hi, > So - basically you want something like: > > SELECT * from emotions > WHERE emotion_date <= [cutoff time] > ORDER BY calculated_score(date_epoch,full_rating) > LIMIT 300 yes, thats it -- nearly :-) In detail the calculated_score is: (cutoff_time - creation_time) + (sum_of_rating_points

Re: [SQL] Returning multiple Rows from PL/pgSQL-Function

>> How should I do this? > > Can't at the moment. ups, OK -- then I misunderstand something ;) >> or, in more detail the exact function: >> >> >>CREATE FUNCTION get_emotions (timestamp) RETURNS SETOF records AS >> ' >> DECLARE >> start ALIAS FOR $1; >>

[SQL] Returning multiple Rows from PL/pgSQL-Function

Hi, I want to create a function (PL/pgSQL), which return multiple rows. But it fails -- when Creating the function, I get a notice: NOTICE: ProcedureCreate: return type 'records' is only a shell When executing it, this error: ERROR: fmgr_info: function 0: cache lookup failed How shoul

Re: [SQL] PostgreSQL HOWTO

Hi, Poet/Joshua Drake wrote: > > >it seems that the author never used any other think then PHP ... > > I am afraid I would disagree. I have used all of the languages he metions > and for the Web, PHP is the best. hmm, i guess it's not a good place for a PHP/Perl war here ;) but: The author wrot

Re: [SQL] PostgreSQL HOWTO

Kaare Rasmussen wrote: > > Whoever wrote this is putting the PostgreSQL community in a bad light: > > http://www.linux.org/docs/ldp/howto/PostgreSQL-HOWTO-4.html it seems that the author of this HOWTO is a little bit mad in brain: from http://www.linux.org/docs/ldp/howto/PostgreSQL-HOWTO-11.

[SQL] Using INDEX on date/time values // Re: how to select a time frame on timestamp rows.

Hi, Peter Eisentraut schrieb: > > > today i was trying to perform a query on a database using a time stamp > > field, i need to get all records which belong to year 2000, month 11, [...] > select user_name from tbacct where extract(month from acct_timestamp) = 11 ... is there any way of u

Re: [SQL] How to represent a tree-structure in a relationaldatabase

Hi, miguel sofer wrote: > > Sorry, I never got around to completing this, or thinking any further. My > other files are definitely not in a usable state right now. I hope to be > able > to improve things over the (southern) summer holidays, so there may be > news > soon - but do not hold your br

Re: Secure Messaging Non-Delivery Report: Re: [SQL] How to representa tree-structure in a relationaldatabase

Hi, The Hermit Hacker schrieb: > > oh, wait, you didn't want me to remove dana from all lists? :) if > offensive on one, I figure its offensive on all ... saves time, no? hmm, perhaps the admin of him give OK to receive mails in future ... ;-) Ciao Alvar -- Alvar C.H. Freude | [EMAIL P

Re: Secure Messaging Non-Delivery Report: Re: [SQL] How to represent a tree-structure in a relationaldatabase

Hi Security-Master, [EMAIL PROTECTED] wrote: > > When [EMAIL PROTECTED] sent e-mail to [EMAIL PROTECTED] >(1/255/1) > The message was blocked by TFS Secure Messaging > When [EMAIL PROTECTED] sent e-mail to [EMAIL PROTECTED] >(1/255/1) > The message was blocked by TFS Secure Messaging please c

Re: [SQL] How to represent a tree-structure in a relationaldatabase

Hi, > > > I once started writing a small paper on this subject; it is still in a > > rather preliminary state. > > > > You can download the draft (and some ill documented code, 53kB) from > > http://www.utdt.edu/~mig/sql-trees > i guess, with base 160 encoding there might be a problem: if post

Re: [SQL] How to represent a tree-structure in a relationaldatabase

Hi, miguel sofer wrote: > > I once started writing a small paper on this subject; it is still in a > rather preliminary state. > > You can download the draft (and some ill documented code, 53kB) from > http://www.utdt.edu/~mig/sql-trees ah, this looks very, very nice! on page 5ff you describ

Re: [SQL] Using Array-Values in subselect

Tom Lane schrieb: > > The array stuff is pretty simplistic at the moment, and could be taken > a lot further if there were someone who wanted to work on it. > (hint hint) :) If i had time, this would be interesting, but I think my C experiences are not very good and some years old (I like much

Re: [SQL] Using Array-Values in subselect

Roberto Mello schrieb: > Looks like you want something similar to Oracle's CONNECT BY statement. > There are some solutions to that. At OpenACS we had to deal with that so > implemented something like what you described here. > However, the methods described by Joe Celko is his boo

[SQL] Using Array-Values in subselect

Hi, i want to create a linked structure of values. Each text has an id, an array of children ids and the value itself. CREATE TABLE structure ( id int8, children int8[], value text ); Now i want to select all values which are connected to a given parent #x at once. My firs