What is the alternate of FILTER below Postgresql 9.4 ?

From: Arup Rakshit <aruprakshit(at)rocketmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: What is the alternate of FILTER below Postgresql 9.4 ?
Date: 2015-02-24 16:02:59
Message-ID: 10038948.Y5rVLs9M29@linux-wzza.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Please look at my query :

[shreyas(at)rails_app_test (master)]$ rails db
psql (9.4.1)
Type "help" for help.

app_development=# select id, location, name from people;
id | location | name
----+----------+------
2 | X | foo
3 | X | foo
4 | Y | foo
(3 rows)

app_development=# SELECT COUNT(id) FILTER(WHERE lower(location) != 'x') AS Non_X_loc, COUNT(id) FILTER (WHERE lower(location) = 'x') AS X_loc FROM "people";
non_x_loc | x_loc
-----------+-------
1 | 2
(1 row)

This *FILTER* method is available from 9.4, How can I get the same output below 9.4 version ?

--
================
Regards,
Arup Rakshit
================
Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.

--Brian Kernighan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Drolet 2015-02-24 16:06:32 Re: Sequences not moved to new tablespace
Previous Message Guillaume Drolet 2015-02-24 15:59:55 Re: Sequences not moved to new tablespace