Re: [GENERAL] ts_headline

2008-02-23 Thread Oleg Bartunov
On Sat, 23 Feb 2008, Stephen Davies wrote: As it turns out, all I needed was in the doco but the key element - the first config arg to ts_headline - was not in any of the examples so I missed it. aha, Original one were based on default configuration, but then concept was changed, but the exam

[GENERAL] Phrase searching

2008-02-23 Thread Stephen Davies
As I understand it, the way that BASIS does phrase searching is based on first parsing the base text to "context units" (sentences and/or paragraphs) and then calculating position for tokens within those context units. That is, a token might have position 3 in context unit 4. All of this is sto

Re: [GENERAL] Queries w/ "computed" table names? (eval in Pg?)

2008-02-23 Thread Kynn Jones
On Fri, Feb 22, 2008 at 6:51 PM, Steve Atkins <[EMAIL PROTECTED]> wrote: > > On Feb 22, 2008, at 3:40 PM, Kynn Jones wrote: > > > Hi. Suppose I have a database that contains a "meta table" that > > holds the names of other the tables in the database, keyed by human- > > readable but longish strin

Re: [GENERAL] need some help on figuring out how to write a query

2008-02-23 Thread Jorge Godoy
Em Friday 22 February 2008 13:10:20 Justin escreveu: > I'm not after small code i'm after maintainable code where the date > range for this report would be always changing. So if i can get it to > one select statement i would on have to pass in some variables and it > would create the moving avera

Re: [GENERAL] PostgreSQL's hashing function?

2008-02-23 Thread Kynn Jones
On Fri, Feb 22, 2008 at 8:12 PM, Greg Stark <[EMAIL PROTECTED]> wrote: You could use hashtext() which is Postgres's internal hash function. Awesome! > There's some possibility it could change in future versions of Postgres > though. I can live with that, especially if all that changes is the

Re: [GENERAL] joining on concatonation?

2008-02-23 Thread Osvaldo Kussama
2008/2/22, blackwater dev <[EMAIL PROTECTED]>: > I have a query that is driving me nuts. In one table we have data that is > split between two columns and I'm trying to pull in all values from another > table where that column is represented by one piece of data. Also, all the > info in column2 i

[GENERAL] Invalid username specified: A required privlege is not held by the client

2008-02-23 Thread Dee
I am trying to install version 8.3 on windows 2000. I created a Local account named "postgres" and granted it "Log on as a service" and "Log on locally" rights as described here http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html#3.3 But when I get to the "Install as Servi

[GENERAL] Benetl version 1.5

2008-02-23 Thread Benoît Carpentier
Dear all, A new version (1.5) of Benetl has been released. It is supporting postgreSQL 8.3.x and is better supporting english locale for floats. It is also now possible to choose to write datas every x lines. Thanks for your interest. Regards, -- Benoît Carpentier www.benetl.net Founder of Be

[GENERAL] VTD-XML 2.3 released

2008-02-23 Thread jimmy Zhang
VTD-XML 2.3 is now released. To download the latest version please visit http://sourceforge.net/project/showfiles.php?group_id=110612&package_id=120172. Below is a list of new features and enhancements in this version. a.. VTDException is now introduced as the root class for all other VTD-XML's

Re: [GENERAL] unnesesary sorting after Merge Full Join

2008-02-23 Thread Decibel!
On Feb 21, 2008, at 4:08 AM, Alexey Nalbat wrote: I'd like to use ORDER BY in any specified order and LIMIT, OFFSET for paging query results. The query is FULL OUTER JOIN of two tables by field id. I think the results of Merge Full Join to be ordered by some "combined id". And there is no need

Re: [GENERAL] Approaches for Lookup values (codes) in OLTP application

2008-02-23 Thread Decibel!
On Feb 15, 2008, at 1:43 PM, Scott Marlowe wrote: Generally speaking, I tend towards using the real value as the key and foreign key in lookup tables, but occasionally using an artificial numeric key is a better choice. Something to consider here... any table that will have either a lot of r

Re[GENERAL] turn Query with simple function

2008-02-23 Thread dvanatta
I'm new to PostgreSQL, moving over from SQL Server and stored procs to PostgreSQL 8.3 and it's functions and having some difficulty. With SQL Server I didn't have to define types and return those types from stored procs which was convenient. I came across Return Query but can't find much info on

[GENERAL] 8.3 INSTALL: Why must I backup while my database is busy?

2008-02-23 Thread ljb
>From the 8.3.0 INSTALL file: | Upgrading | | 1. If making a backup, make sure that your database is being updated. Ouch. Revert to the language in 8.2, perhaps: 1. Make sure that your database is not updated during or after the backup. ---(end of broadcast)

Re: Re[GENERAL] turn Query with simple function

2008-02-23 Thread Rodrigo E. De León Plicet
On 2/23/08, dvanatta <[EMAIL PROTECTED]> wrote: > How should this function be written? Define output parameters in the function and return SETOF RECORD, e.g.: --- SQL --- CREATE OR REPLACE FUNCTION GET_FOO1(BAR INT, OUT BAZ INT, OUT ZAB INT) RETURNS SETOF RECORD AS $BODY$ SELECT $1, $1; $BODY$ LA

[GENERAL] APEX / HTML DB for PostgreSQL

2008-02-23 Thread justin tocci
In its most basic form a great tool would just start as a pl/pgsql or pl/perl function that could be used to call a table and have it output a batch of records to an editable html form or a colored pdf for nice reports. There would need to be some kind of interface for Apaché of course. A