a thoughtful web.
Good ideas and conversation. No ads, no tracking.   Login or Take a Tour!
comment
mk  ·  888 days ago  ·  link  ·    ·  parent  ·  post: Pubski: July 6, 2022

I'm learning/using PostGIS atm. It amazes me what can be done.

Tangentially, I have a very very basic Postgres question: Can you query Postgres and just get the value(s) from a row without JSON or any other formatting?

i.e.

  SELECT v1 FROM things WHERE id = 3;

..and if v1 is "foo", it only returns "foo". Not a table or JSON array with "foo" in it, etc.