Questions tagged [string-representation]
A string representation is a textual form of a non-textual value (e.g. a number).
9
questions
30
votes
4
answers
41k
views
Unquoting JSON strings; print JSON strings without quotes
SELECT json_array_elements('["one", "two"]'::json)
gives result
| json_array_elements |
| :------------------ |
| "one" |
| "two" |
I would like to ...
- 425
1
vote
1
answer
829
views
Missing "public" schema when converting a "regclass" value to text
I am writing a script in which I need to parse the name of a table (in regclass). The parsing (with parse_ident()) works so far. However, the script fails when the table is in the public schema ...
- 3,325
1
vote
1
answer
962
views
PostgreSQL function's input/output as JavaScript nested objects [closed]
I am looking for a simple/clean way that can be used consistently to automatically input JavaScript nested objects to user-defined PostgreSQL functions and also automatically output to JavaScript ...
- 21
10
votes
1
answer
6k
views
Why is to_char left padding with spaces?
When ever I use 099 indicating 3 digits 0-padded, I'm getting spaces on the left side.
SELECT '>' || to_char(1, '099') || '<';
?column?
----------
> 001<
(1 row)
Why is to_char left ...
- 61.5k
0
votes
1
answer
118
views
How to get one complete column in mysql?
I have a script that will fetch Last_Error in mysql slave in a particular interval of time and write that to a file.
To fetch Last_Error, currently I am using below command in the script.
mysql -u ...
- 101
29
votes
1
answer
8k
views
What date/time literal formats are LANGUAGE and DATEFORMAT safe?
It is easy to demonstrate that many date/time formats other than the following two are vulnerable to misinterpretation due to SET LANGUAGE, SET DATEFORMAT, or a login's default language:
yyyyMMdd ...
- 179k
2
votes
1
answer
53
views
Which databases provide string pooling?
Suppose I have many data objects that include very many share very many identical strings (e.g. tags, URLs, "DEBUG"/"TRACE"/"INFO", etc...).
Which databases (if any) pool identical strings ...
- 171
4
votes
1
answer
483
views
How is encoding done in SQL database tables for pattern matching?
Are strings in table columns represented as bit patterns or Unicode? Does the database engine bring them into memory in a different representation character set from the disk-persisted ...
- 41
7
votes
2
answers
7k
views
Why isn't to_char IMMUTABLE, and how can I work around it?
How can I index a to_char() of a column?
I have tried:
adam_db=> CREATE INDEX updates_hourly_idx
ON updates (to_char(update_time, 'YYYY-MM-DD HH24:00'));
But got the error:
ERROR: ...
- 11.4k