Timeline for Casting an array of texts to an array of UUIDs
Current License: CC BY-SA 4.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 7, 2023 at 5:05 | history | edited | Erwin Brandstetter | CC BY-SA 4.0 |
link, format
|
| Jun 15, 2020 at 9:05 | history | edited | CommunityBot |
Commonmark migration
|
|
| Feb 26, 2020 at 0:00 | history | edited | Erwin Brandstetter | CC BY-SA 4.0 |
link
|
| Nov 9, 2018 at 1:06 | comment | added | Erwin Brandstetter |
No matter how you created it, you can get the (re-engineered) SQL statement easily with various client tools like pgAdmin3 or pgAdmin4. Or \dt tbl in psql, but a CREATE TABLE script is best since we can use that to test immediately.
|
|
| Nov 9, 2018 at 1:03 | vote | accept | Sig | ||
| Nov 9, 2018 at 1:03 | comment | added | Sig | Thanks, I didn't create the table directly in SQL. That is the reason I missed a few details. Next time I will try to get the full picture upfront. | |
| Nov 9, 2018 at 0:57 | comment | added | Erwin Brandstetter |
That's why I strongly suggest to always start questions by disclosing the table definition (CREATE TABLE statement). You obviously have an undisclosed DEFAULT value for the column. Added solution above.
|
|
| Nov 9, 2018 at 0:56 | history | edited | Erwin Brandstetter | CC BY-SA 4.0 |
add ALTER statement
|
| Nov 9, 2018 at 0:49 | comment | added | Sig | Thanks, I have tried it but it seems not to work. See my update. | |
| Nov 9, 2018 at 0:46 | comment | added | Erwin Brandstetter |
@Sig: I added the requested ALTER TABLE statement.
|
|
| Nov 9, 2018 at 0:45 | history | edited | Erwin Brandstetter | CC BY-SA 4.0 |
add ALTER statement
|
| Nov 8, 2018 at 16:19 | history | edited | Erwin Brandstetter | CC BY-SA 4.0 |
added 21 characters in body
|
| Nov 8, 2018 at 16:09 | history | edited | Erwin Brandstetter | CC BY-SA 4.0 |
add more
|
| Nov 8, 2018 at 15:37 | history | answered | Erwin Brandstetter | CC BY-SA 4.0 |