Re: [SQL] Way to reverse ordering of an IP ... ?

2006-09-05 Thread Philippe Lang
[EMAIL PROTECTED] wrote: > for Reverse DNS purposes, I'd like to reverse an IP ... > > ie: 200.46.204.1 would become 1.204.46.200 > > Is there an easy way of doing this *short* of writing a > plpgsql function? > > I've checked the docs, and found the substring() function > that allows for using

[SQL] Query regarding to MS reporting services (Grand total problem)

2006-09-05 Thread Dinesh Tiwari
Hi, I have a problem reagarding Grand Total in the table footer. I am showing only top 10 seeling for each department in report but i want sum of whole table seelings in table footer. not only 10 sellings which are shown in report. I want the sum of all 40 thousand rows.   How i can do it. If a

[SQL] Way to reverse ordering of an IP ... ?

2006-09-05 Thread Marc G. Fournier
for Reverse DNS purposes, I'd like to reverse an IP ... ie: 200.46.204.1 would become 1.204.46.200 Is there an easy way of doing this *short* of writing a plpgsql function? I've checked the docs, and found the substring() function that allows for using a regex, which I thought might allow thi

Re: [SQL] Postgres regexp matching failure?

2006-09-05 Thread Aaron Bono
On 9/5/06, Alvaro Herrera <[EMAIL PROTECTED]> wrote: In Perl at least, \b is a word boundary.  In PostgreSQL (and probablyTcl as well) it's a backslash AFAICT.More specifically, Perl, Java and Python interpret \b as a backspace in the Character class only (got that from the Regular _expression_ poc

Re: [SQL] Subquery alternatives?

2006-09-05 Thread codeWarrior
I dont think you need the double-left join SELECT * FROM STORIES ST LEFT JOIN TAGS TG ON TG.tagkey = ST.storykey WHERE TG.tag = "science" "MRKisThatKid" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi, i've posted this in various places but I'm really struggling to > find

Re: [SQL] Postgres regexp matching failure?

2006-09-05 Thread Tom Lane
Mario Splivalo <[EMAIL PROTECTED]> writes: > So, I guess it's obvious that postgres doesn't treat regular expressions > the same way as java/perl/pyton/php/awk/sed do... When you get into stuff as arcane as word-boundary constraints, you'll find that regexes are not NEARLY as well standardized as

Re: [SQL] Postgres regexp matching failure?

2006-09-05 Thread Alvaro Herrera
Mario Splivalo wrote: > On Tue, 2006-09-05 at 10:21 -0400, Alvaro Herrera wrote: > > Mario Splivalo wrote: > > > On Tue, 2006-09-05 at 08:42 -0500, Aaron Bono wrote: > > > > On 9/5/06, Mario Splivalo <[EMAIL PROTECTED]> wrote: > > > > > > > > pulitzer2=# select 'stop works' ~ '^\s*

Re: [SQL] Postgres regexp matching failure?

2006-09-05 Thread Mario Splivalo
On Tue, 2006-09-05 at 10:21 -0400, Alvaro Herrera wrote: > Mario Splivalo wrote: > > On Tue, 2006-09-05 at 08:42 -0500, Aaron Bono wrote: > > > On 9/5/06, Mario Splivalo <[EMAIL PROTECTED]> wrote: > > > > > > pulitzer2=# select 'stop works' ~ '^\s*(?:[\ > > > +|-]|(?:[sS][t

Re: [SQL] pg_dump

2006-09-05 Thread Tom Lane
"M. Santosa" <[EMAIL PROTECTED]> writes: > I've install postgres in linux. > but pg_dump its not working at all. > -bash-3.00$ psql -l > ERROR: relation "pg_catalog.pg_user" does not exist IIRC, this is a symptom of selinux having interfered with initdb. Get a newer copy of the selinux policy pac

Re: [SQL] Postgres regexp matching failure?

2006-09-05 Thread Alvaro Herrera
Mario Splivalo wrote: > On Tue, 2006-09-05 at 08:42 -0500, Aaron Bono wrote: > > On 9/5/06, Mario Splivalo <[EMAIL PROTECTED]> wrote: > > > > pulitzer2=# select 'stop works' ~ '^\s*(?:[\ > > +|-]|(?:[sS][tT][oO][pP]\b)).*$'; > > ?column? > > -- > >

Re: [SQL] Postgres regexp matching failure?

2006-09-05 Thread Mario Splivalo
On Tue, 2006-09-05 at 08:42 -0500, Aaron Bono wrote: > On 9/5/06, Mario Splivalo <[EMAIL PROTECTED]> wrote: > > pulitzer2=# select 'stop works' ~ '^\s*(?:[\ > +|-]|(?:[sS][tT][oO][pP]\b)).*$'; > ?column? > -- > f > (1 row) >

Re: [SQL] Postgres regexp matching failure?

2006-09-05 Thread Mario Splivalo
On Tue, 2006-09-05 at 10:11 -0400, Tom Lane wrote: > Mario Splivalo <[EMAIL PROTECTED]> writes: > > Now, here is what happens if I try this in postgres: > > > pulitzer2=# select '+mario' ~ '^\s*(?:[\+|-]|(?:[sS][tT][oO][pP]\b)).*$'; > > I'm thinking you've forgotten to double your backslashes. >

Re: [SQL] Postgres regexp matching failure?

2006-09-05 Thread Tom Lane
Mario Splivalo <[EMAIL PROTECTED]> writes: > Now, here is what happens if I try this in postgres: > pulitzer2=# select '+mario' ~ '^\s*(?:[\+|-]|(?:[sS][tT][oO][pP]\b)).*$'; I'm thinking you've forgotten to double your backslashes. regards, tom lane -

Re: [SQL] Postgres regexp matching failure?

2006-09-05 Thread Aaron Bono
On 9/5/06, Mario Splivalo <[EMAIL PROTECTED]> wrote: pulitzer2=# select 'stop works' ~ '^\s*(?:[\+|-]|(?:[sS][tT][oO][pP]\b)).*$'; ?column?-- f(1 row)Here, postgres should return true, but it gives me false.  \b is a back-space - is that what you are wanting there?  If I remove it I get tru

Re: [SQL] pg_dump

2006-09-05 Thread Andrew Sullivan
On Tue, Sep 05, 2006 at 02:22:29PM +0700, M. Santosa wrote: > and if i execute the psql with list database option, the result is error > > -bash-3.00$ psql -l > ERROR: relation "pg_catalog.pg_user" does not exist This looks to me like you have more than one postmaster installed, and you've got

[SQL] Postgres regexp matching failure?

2006-09-05 Thread Mario Splivalo
I have an regular expression, wich works fine in Java or python, but I don't seem to be able to make it work in postgres. Regular expression needs to match everything begining with '+' (plus sign) or letters 'STOP', 'stop', 'StoP', or any other combination pronounced 'stop'. Here is the python exa

[SQL] pg_dump

2006-09-05 Thread M. Santosa
I've install postgres in linux. but pg_dump its not working at all. if i execute the pg_dump to the file like this pg_dump -Upostgres -dpostgres > file.dmp the file file.dmp is empty and if i execute the psql with list database option, the result is error -bash-3.00$ psql -l ERROR: relation