Skip site navigation (1)
Skip section navigation (2)
Type casting is required since 8.3, try
SELECT substring(date :: varchar from 1 for 7) AS stryearmonth, COUNT(id) AS countofnumber FROM (SELECT * from downloads ) AS foo GROUP BY stryearmonth ORDER BY stryearmonth ASC
Bye...
Ludwig
Peripheral Links
Header And Logo
|
Site Navigation
Re: Substring Problem
- From: <ludwig(at)kni-online(dot)de>
- To: <pgsql-general(at)postgresql(dot)org>
- Subject: Re: Substring Problem
- Date: Tue, 13 May 2008 15:56:38 +0200
- Message-id: <1833634(dot)798471210686998360(dot)JavaMail(dot)servlet(at)pustefix156(dot)kundenserver(dot)de>
Type casting is required since 8.3, try
SELECT substring(date :: varchar from 1 for 7) AS stryearmonth, COUNT(id) AS countofnumber FROM (SELECT * from downloads ) AS foo GROUP BY stryearmonth ORDER BY stryearmonth ASC
Bye...
Ludwig
Hi there,
it seems to work with 8.1, but not anymore with 8.3. What is wrong with this substring request? Or is it some installation issue? Thanks for any suggestion! SELECT substring(date from 1 for 7) AS stryearmonth, COUNT(id) AS countofnumber FROM (SELECT * from downloads ) AS foo GROUP BY stryearmonth ORDER BY stryearmonth ASC It says: ERROR: function pg_catalog.substring(date, integer, integer) does not exist LINE 1: SELECT substring(date from 1 for 7) as stryearmonth, COUNT(i...
- Follow-Ups:
- Re: Substring Problem
- From: Tino Wildenhain
- Re: Substring Problem
- Prev by Date: Re: Substring Problem
- Next by Date: PG -v- MySQL
- Previous by thread: Re: Substring Problem
- Next by thread: Re: Substring Problem
- Indexes: