| From: | Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> |
|---|---|
| To: | Chris Barnes <compuguruchrisbarnes(at)hotmail(dot)com> |
| Cc: | Postgres General Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Using concatenation operator |
| Date: | 2010-08-17 17:17:04 |
| Message-ID: | 82893A07-0807-4B27-B6C7-9ECA3559B5DC@solfertje.student.utwente.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 17 Aug 2010, at 18:28, Chris Barnes wrote:
> psql database -t -c "select ||'select count (*) from '||schemaname||'.'||relname from pg_stat_user_tables where relname like 'table_%'"|more
> ERROR: operator does not exist: || unknown
> LINE 1: select ||'select count (*) from '||schemaname||'.'||relname ....
> ^
> HINT: No operator matches the given name and argument type(s).
> You might need to add explicit type casts
There's nothing before the first concat operator ;)
Alban Hertroys
--
Screwing up is an excellent way to attach something to the ceiling.
!DSPAM:737,4c6ac41b967634613617124!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc-André Lalonde | 2010-08-17 19:02:07 | trying to compile libpq with VS 2005 and static runtime |
| Previous Message | Chris Barnes | 2010-08-17 16:28:00 | Using concatenation operator |