Tuesday, October 31, 2017

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

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 <rob@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+unsubscribe@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.

--
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAE1wr-zzhAoJLhdAr7gPDKJgr9QUxLtKZd66TyYAO3Ffqm5yWQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment