Re: [google-cloud-sql-discuss] Re: Postgres array_to_string not working

28 views
Skip to first unread message
Message has been deleted
Message has been deleted

Vladimir Rusinov

unread,
Oct 31, 2017, 11:24:58 AM10/31/17
to google-cloud...@googlegroups.com
Hi,

Are you sure error you are seeing is due to array_* functions? What error do you see?
I just tried executing `SELECT array_to_string(ARRAY[1, 2, 3, NULL, 5], ',', '*');` on my test instance at it seems to work as expected. I have also checked a few other array function and all of them seem to work.

In general, Cloud SQL version of PostgreSQL behaves the same way as any other PostgreSQL installation, except for cases listed here: https://cloud.google.com/sql/docs/postgres/features#differences-pg

--
Vladimir Rusinov
PostgreSQL SRE, Google Ireland

Google Ireland Ltd.,Gordon House, Barrow Street, Dublin 4, Ireland
Registered in Dublin, Ireland
Registration Number: 368047

On Tue, Oct 31, 2017 at 2:19 PM, R S <r...@undeadindustries.com> wrote:
I just realized no array functions are working? So array_append is not recognized either.

On Tuesday, October 31, 2017 at 10:04:22 AM UTC-4, R S wrote:
Google cloud postgres does not seem to recognize the array_to_string function.

Has anyone else have this working?

My psql client is 9.6.x

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsub...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/7d0cb0ea-9b43-4938-9922-c8e24853c489%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

R S

unread,
Oct 31, 2017, 11:48:20 AM10/31/17
to Google Cloud SQL discuss
Deleted me post. Realized what I was doing wrong.

Thanks!
Reply all
Reply to author
Forward
0 new messages